Search notes:

$ORACLE_HOME/rdbms/admin/utlxplp.sql

utlxplp.sql is an SQL script to display the plan table output including parallel execution processing.
With SQL*Plus it is recommended to set linesize to 130 and pagesize to 0.
The executable content of this script is quite simple:
set markup html preformat on
select * from table(dbms_xplan.display());

See also

utlxpls.sql is a similar script, but for serial processing
The explain plan SQL statement.

Index