2 Replies Latest reply: Mar 2, 2013 1:30 PM by user511621 RSS

    sqlprofile not found in v$sql

    user511621
      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
          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
            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