This discussion is archived
0 Replies Latest reply: Feb 5, 2013 6:41 AM by Cherif bh RSS

DBMS_XPLAN.diff_plan_awr -ORA-13608

Cherif bh Explorer
Currently Being Moderated
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?

Legend

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