Search notes:

$ORACLE_HOME/rdbms/admin/catplan.sql

catplan.sql creates the table plan_table$ and the public synonym plan_table that refers to plan_table$.
The object named plan_table is used by the explain plan SQL statement to insert its result when executed.

See also

The autotrace feature of SQL*Plus.
utlxplan.sql

Index