Dropping a possibly exististing table SYS.PLAN_TABLE$ and public synonym PUBLIC.PLAN_TABLE will avoid having invalid packages and a non-valid Oracle Server component in DBA_REGISTRY.
This will apply to all upgrades to 10.2.0.4, 11.1.0.6 and 11.1.0.7.
drop table plan_table$; drop public synonym plan_table;
This issue has been introduced with the package DBMS_SQLPA for the SQL Performance Analyzer.
If you hit this issue already the following actions will solve it:
@catplan.sql -- recreate the plan table @dbmsxpln.sql -- reload dbms_xplan spec @prvtxpln.plb -- reload dbms_xplan implementation @prvtspao.plb -- reload dbms_sqlpa alter package SYS.DBMS_SUMADVISOR compile; alter package SYS.DBMS_SUMADVISOR compile body;
You’ll find further information:
Your command font are barely visible sir. Please enlarge it. Good article BTW.
This is a very old blog post which I migrated over from blogs.oracle.com years ago.
I changed it now to the new format – hope this helps.
Cheers
Mike