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?
I found this page:
The section "Transporting SQL Profiles Between Databases" describes a procedure in seven steps:
The detailed steps are in the page I linked to.
I hope this helps.