explain plan for select * from v$sql_plan; select * from table(dbms_xplan.display(format=>'basic')); -- -- -------------------------------------- -- | Id | Operation | Name | -- -------------------------------------- -- | 0 | SELECT STATEMENT | | -- | 1 | FIXED TABLE FULL| X$KQLFXPL | -- --------------------------------------