Database Administration (MOSC)

MOSC Banner

Error: cannot fetch last explain plan from PLAN_TABLE

edited Dec 5, 2014 11:53AM in Database Administration (MOSC) 8 commentsAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center