plan table

SQL> explain plan for select count(*) from tablo;
SQL> @?/rdbms/admin/utlxpls.sql

On version up to and including 9i, use the utlxplan.sql script to createthe plan table as instructed below.
SQL> @?/rdbms/admin/utlxplan
On 10g and above there is a new script - catplan.sql - to create the plan
table that creates a public plan table as a global temporary table
accessible from any schema.
SQL> @?/rdbms/admin/catplan
Note that the plan table format can change between versions so ensure
that it is created using the utlxplan script from the current version.

sapnotes:#1303908