Error: cannot fetch last explain plan from PLAN_TABLE
Hi Gurus,
Oracle:11203
OS:RHEL 6
I'm getting the error "Error: cannot fetch last explain plan from PLAN_TABLE" whenever i try to see the execution plan from using "DBMS_XPLAN.DISPLAY".
SQL> select sysdate from dual;
SYSDATE
---------
24-NOV-14
SQL> select * from table(dbms_xplan.display);
PLAN_TABLE_OUTPUT
--------------------------------------------------------------------------------
Error: cannot fetch last explain plan from PLAN_TABLE
SQL> select object_name,object_type,owner from dba_objects where object_name='PLAN_TABLE';
OBJECT_NAME OBJECT_TYPE OWNER
--------------- ------------------- ------------------------------
PLAN_TABLE SYNONYM PUBLIC
Please let me know how to fix the error.
Thanks