SQL Performance (MOSC)

MOSC Banner

copy sql profile from one db to another db

edited May 23, 2013 5:28AM in SQL Performance (MOSC) 8 commentsAnswered ✓
 A question about sql profiles:I run sql tuning job in production.  It recommends using sql profile on some sqls, but I don't want to implement it directly in production.  I'd like to be able to create the same profile in another database, test it, verify the impfrovments and then schedule it to go in production.

How can I take something like "create sql profile on ....<sql statement> from one database and run it in another database?

Thanks

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center