Dbms_xplan is a method for:
It displays:
It includs the supplemental information at the bottom of the report (new in Oracle9i release2)
to format and display the contents of a plan table. The query :
Select * From table( dbms_xplan.display)
Will perform the same function than the @?rdms\admin\utlxpls.sql
Using it with the VSQL_PLAN dynamic performance view, we can easily dump the query plans for already executed statements, directly from the database : Actual Plan with DBMS XPLAN