5 Replies Latest reply: Jan 15, 2013 1:06 AM by Uwehesse-Oracle RSS

    From Oracle database to EXADATA

    Xavi
      Hi, I'm doing research on which impact would have in my application (ETL) moving from Oracle to EXADATA.

      How, where can I find info about this issue?

      Thanks in advance
        • 1. Re: From Oracle database to EXADATA
          Uwehesse-Oracle
          As the famous quote says: 'Exadata is still Oracle!'
          In other words, your application will most likely work the same as before - but 10 times faster :)

          Seriously, you gave us too few details to say anything specific.

          One point: ETL has usually flat files involved. You would put them into DBFS on Exadata.
          If you haven't heard about it yet: It looks like an ordinary filesystem for your ETL process but it is spread across (almost) all drives of the storage servers.

          Kind regards
          Uwe Hesse

          "Don't believe it, test it!"
          http://uhesse.com
          • 2. Re: From Oracle database to EXADATA
            tychos
            Hi Xavi,
            application (ETL) moving to EXADATA.
            There is little detail in your question.
            We have some ETL target database moved to an Exadata dbm and see the ETL runs on average 5 times faster.
            (The actual ETL application is not installed on Exadata.)
            Regards,
            Tycho
            • 3. Re: From Oracle database to EXADATA
              marksmithusa
              Unless I'm mistaken, there is a 'Exadata simulator' in 11gR2 for non-Exadata databases. Not sure how useful it is as I've never run it myself.

              Certain types of database will run like lightning on Exadata. Others might not even benefit from being clustered.

              Try moving it to RAC first before moving to Exadata. It's a lot of money to spend if you can't determine whether or not you'll see the improvements to be worth it (but then again, so is RAC - you need to really understand your application to have a reasonable idea on whether you can cluster a database).
              • 4. Re: From Oracle database to EXADATA
                Xavi
                Then Accessing EXADATA is like accesing any other Oracle Database?
                • 5. Re: From Oracle database to EXADATA
                  Uwehesse-Oracle
                  Exactly. If you have been on Oracle 11gR2 RAC before, the viewpoint of the application (e.g. the tnsnames.ora) remains unchanged.

                  Kind regards
                  Uwe Hesse

                  "Don't believe it, test it!"
                  http://uhesse.com