During a lot of SQL Performance activities I saw all the time the following message but why?
Note ----- - 'PLAN_TABLE' is old version
Yes, I did a few days before an Upgrade from 220.127.116.11 -> 18.104.22.168. Now I start to check out some important SQL Queries but I the „old version“ message
sqlplus set autotrace traceonly explain select * from dual; and again Note ------ 'PLAN_TABLE' is old version
Problem is that this message came up while the plan_table came from the previous version in my case 22.214.171.124. So the solution for this is very easy
In the new environment here 126.96.36.199 SQL> connect sys as sysdba SQL> drop table plan_table$; SQL> @?/rdbms/admin/catplan
This shoud fix the problem and if not?
Okay it could be possible that you should drop the plan_table as Schema User and then run the the SQL again.
Here an example output: Note ----- - dynamic statistics used: dynamic sampling (level=2) - automatic DOP: Computed Degree of Parallelism is 8 because of degree limit - parallel scans affinitized for buffer cache