Search notes:

$ORACLE_HOME/rdbms/admin/utlxplan.sql

utlxplan.sql is a template to create a PLAN_TABLE into which the explain plan statement writes its results.
In an ordinary Oracle installation, the «real» plan_table (or rather a public synonym with that name) is created by catplan.sql.

See also

$ORACLE_HOME/rdbms/admin/catplan.sql
$ORACLE_HOME/rdbms/admin

Index