DBMS_XPLAN

One more way we can see the Explain Plan by using DBMS_XPLAN package.

• DBMS_XPLAN automatically queries the last plan in PLAN_TABLE.
• It uses a TABLE() function with another pipelined function.

Example of DBMS_XPLAN:

select * from table(dbms_xplan.display);