DBMS_XPLAN

Dbms_xplan is a method for querying and displaying the Oracle Database - Execution/Query Plan output. It’s a function that return simply a collection, which is procedurally Oracle Database - Explain Plan output, including the supplemental information at the bottom of the report (new in Oracle9i release2)

The query :

SELECT * FROM TABLE( dbms_xplan.display)

Will perform the same function than the utlxpls.sql

Using it with the V$SQL_PLAN dynamic performance view, we can easily dump the query plans for already executed statements, directly from the database : Actual Plan with DBMS XPLAN