This discussion is archived
2 Replies Latest reply: Mar 2, 2013 11:30 AM by user511621 RSS

sqlprofile not found in v$sql

user511621 Newbie
Currently Being Moderated
HI

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.

Please suggest.
  • 1. Re: sqlprofile not found in v$sql
    sb92075 Guru
    Currently Being Moderated
    user511621 wrote:
    HI

    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.

    Please suggest.
    did you start a new session?


    How do I ask a question on the forums?
    SQL and PL/SQL FAQ
  • 2. Re: sqlprofile not found in v$sql
    user511621 Newbie
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points