Question:
I am getting this message when using "set autotrace on" for a query:
- 'PLAN_TABLE' is old
version
How to I get the current plan table for my SQL explain
plans?
Answer:
Getting the new plan table is easy. The "old"
plan table is utlxplan.sql in
$ORACLE_HOME/RDBMS/ADMIN and the new plan table is
catplan.sql.
You have to temporarily
grant sysdba to the user and follow these steps:
cd
$ORACLE_HOME/RDBMS/ADMIN
sqlplus system manager as sysdba
grant sysdba to myuser;
connect myuser as sysdba
@catplan
revoke sysdba from
myuser;
exit;
This will prevent the old version of the plan table from
being used.