This content has been marked as final. Show 7 replies
Implementing a SQL profile will not always necessarily give you better results for your SQL statement. You should properly test it in your performance testing environment first to make sure that there are no ill-effects.
If you have implemented the SQL profile and you want to revert it back then you can do so via OEM Grid:-
1) Go to the Performance page and click Top Activity
2) Under the Top SQL pane, click the SQL ID of the statement you implemented the profile for
3) Click the Plan Control tab. You should see the the SQL profile you implemented. You can now either disable the profile or delete it.
Hope this helps.
Pavan Kumar wrote:That's a piece of code that will tell you what the profile looks like AFTER you've accepted it.
Additionally, some information the below query can provide the sql profile adjustments.
select sp.sp_name, sa.attr#, sa.attr_val from sqlprof$ sp, sqlprof$attr sa where sp.signature = sa.signature and sp.category = sp.category order by sp.sp_name, sa.attr# ;
There's an example on my blog of a query that works (or did the last time I used it) if you want to see the profile before you accept it: http://jonathanlewis.wordpress.com/2007/02/11/profiles/
For the OP - Oracle gives you the pl/sql call to accept a profile - the package used includes a call to drop the profile.