Today Oracle released a very large „monster“ Upgrade. This July 2017 Update includes the first time the new RU „Release Upgrade“ and RUR „Release Update Revision“ Patches.
To be up to date read the following My Oracle Support Doc-ID’s
Actually I can’t find a FAQ but I think this will come in a few weeks.
Stay tuned :-)
Vor zwei Jahren als Oracle ACE Associate gestartet, wurde ich nun zum Oracle ACE „befördert“. Vielen Dank
Two years ago I started as Oracle ACE Associate and now I was „promoted“ to the Oracle ACE status. Many Thanks
If you need a good overview and introduction in Oracle 12.1 RAC take a look to the following document.
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 184.108.40.206 -> 220.127.116.11. 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 18.104.22.168. So the solution for this is very easy
In the new environment here 22.214.171.124
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