During a lot of SQL Performance activities I saw all the time the following message but why?
- 'PLAN_TABLE' is old version
Yes, I did a few days before an Upgrade from 188.8.131.52 -> 184.108.40.206. Now I start to check out some important SQL Queries but I the „old version“ message
set autotrace traceonly explain
select * from dual;
'PLAN_TABLE' is old version
Problem is that this message came up while the plan_table came from the previous version in my case 220.127.116.11. So the solution for this is very easy
In the new environment here 18.104.22.168
SQL> connect sys as sysdba
SQL> drop table plan_table$;
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:
- 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