Geek Answers Handbook

Oracle & PL / SQL Developer - access predicates and filter predicates are no longer displayed

I am using Allround Automation PL / SQL Developer with Oracle 10g, and today I noticed that explaining the plans no longer displays anything for Access Predicates or Filter Predicates. The only thing that has changed (what I know) is that yesterday I tried to use Oracle Enterprise Manager to explain the query plan, and after that PL / SQL Developer no longer populated these two columns.

I don't know if using OEM can change some of the settings that PL / SQL Developer is now confusing. Anyone have any suggestions?

+4
source share
1 answer

Can you

SELECT owner, table_name FROM dba_tables WHERE table_name = 'PLAN_TABLE'

I have seen many times when different graphical interfaces try to be “useful” and create PLAN_TABLE in a local circuit if it does not exist there, not noticing that there is a synonym for common PLAN_TABLE . And, as a useful graphical interface, they usually create a plan table with an old version of the table, which may not support reporting on such things as access and filter predicates.

If there is only one PLAN_TABLE , can you use the latest utlxplan.sql script from your installation to recreate PLAN_TABLE (or make sure you have the latest version of the table)?

+3
source

More articles:


All Articles