This content has been marked as final. Show 2 replies
user511621 wrote:did you start a new session?
I am using oracle 10gr2
I have created sql profile and implemented it using enterprise manager but when i am checking 'select sql_id, sql_profile from v$sql where sql_id='sqlid#' it is not shwoing anything and query is still using the old plan.
How do I ask a question on the forums?
SQL and PL/SQL FAQ
HI - Yes i have open new session and checked whether sql profile is being used or not but when i checked the cursor plan using below it is still showing the old plan and i have found that sql profile is created in database and it is showing enabled in dba_sql_profile but the strange thing is that it is not being used. PLease suggest
select * from table(dbms_xplan.display_cursor('sqlid'));
Edited by: user511621 on Mar 2, 2013 11:30 AM