Home / server / Questions / 11607
Accepted
DCookie
Asked: 2009-05-24 07:20:20 +0800 CST

"Export" SQL Tuning Profile to another instance?

  • 772

I left work Friday with a long running SQL Tuning Advisor session running from Grid Control in Oracle, on one of our development instances. Some of these sessions take over 4 hours to run, so I prefer to run them on clones of production rather than the production box. My problem is I would like to implement the profiles at times on the production instance. Is there a way to do that?

oracle

1 Answers

  1. Best Answer

    I found this page:

    SQL Profiles - Collection of Information About SQL Profiles

    The section "Transporting SQL Profiles Between Databases" describes a procedure in seven steps:

    1. Create a staging table to store the SQL Profiles
    2. Pack the SQL Profiles to the staging table
    3. Export the table using Datapump or Export/Import
    4. Execute the query in another database without SQL Profiles
    5. Import the SQL Profiles to the database
    6. Unpack the SQL Profiles
    7. Check the SQL Profiles

    The detailed steps are in the page I linked to.

    I hope this helps.

    Edit: Here is another nice link as submitted by Serverfault user David Mann: SQL Profiles.

    • 2