0 Replies Latest reply: Feb 5, 2013 8:41 AM by Cherif bh RSS

    DBMS_XPLAN.diff_plan_awr -ORA-13608

    Cherif bh
      Hi all,

      did someone tested diff_plan_awr.? every time I tested it I get the below error :
      View program sources of error stack?
      ORA-13608: Le nom indiqué, NULL, n'est pas valide.
      ORA-06512: à "SYS.PRVT_ADVISOR", ligne 4040
      ORA-06512: à "SYS.PRVT_ADVISOR", ligne 4052
      ORA-06512: à "SYS.DBMS_ADVISOR", ligne 363
      ORA-06512: à "SYS.DBMS_SQLTUNE", ligne 787
      ORA-06512: à "SYS.DBMS_XPLAN", ligne 6165
      ORA-06512: à "SYS.DBMS_XPLAN", ligne 6995
      ORA-06512: à ligne 7

      declare
      -- Local variables here
      t varchar2(4000);
      begin
      -- Test statements here
      t := DBMS_XPLAN.diff_plan_awr( sql_id => '8hpqkg5x73nq1' , plan_hash_value1 => 1791221528 , plan_hash_value2 => 2965350247) ;
      END;


      This is function is useful but it did not work, could you please help me?