0 Replies Latest reply on Jun 6, 2014 3:10 PM by IamHariKrishna

    sql profile - ambiguity - 11gr2 - not working ??

    IamHariKrishna

      Hi DBAs,

       

      11.2.0.3, RHLE/64 bit, RAC

       

      I have profiled one sql_id to a optimized plan (Plan hash value) - below.

       

      {code}

       

         SNAP_ID   NODE BEGIN_INTERVAL_TIME            SQL_ID        PLAN_HASH_VALUE        EXECS    AVG_ETIME        AVG_LIO SQL_PROFILE

      ---------- ------ ------------------------------ ------------- --------------- ------------ ------------ -------------- ------------------------------

           46258      1 05-JUN-14 07.30.09.041 PM      b4fapzskzv760        15923374            1      619.960    7,505,418.0 coe_b4fapzskzv760_15923374

       

      {code}

       

      But we still reeving alerts from this sql_id, so i just ran SQL_TUNING advisory on this sql_id, it suggest me as follows..

       

      Recommendation (estimated benefit: 99.98%)

        ------------------------------------------

        - Consider accepting the recommended SQL profile.

          execute dbms_sqltune.accept_sql_profile(task_name =>  'b4fapzskzv760_tuning_task_new',task_owner => 'SYS', replace => TRUE);

       

      My question is - this sql_id is already profiled to a optimized plan, whey again advisory suggesting us to accept profile from new tuning_task. Any idea on this ??

       

      Thanks,

       

      Hari