Finally … the two most important fixes for Adaptive Features are included in Oracle 184.108.40.206 October 2017 BP (Bundle Patch). I’m absolutely happy about this. Almost all of my customer and many folks outside I’m dealing with on a regular basis had to request and wait for merge patches over and over again.… [Read More]
DBMS_OPTIM_BUNDLE package got introduced with the April 2014 Exadata 220.127.116.11 Bundle Patch. And it got introduced for all Oracle 18.104.22.168 databases with the April 2017 Bundle Patch (BP).
DBMS_OPTIM_BUNDLE is only available in Oracle 22.214.171.124.
For more information on this package on Exadata in Oracle 126.96.36.199 you may look at:
Purpose of DBMS_OPTIM_BUNDLE package in Oracle 188.8.131.52
The package got introduced to enable module bug fixes which cause an execution plan change in a disabled state.… [Read More]
Recently we got alerted by a customer and a colleague from Italy about an issue with the upgrade from Oracle 12.1.0.x to Oracle 184.108.40.206 if – and only if – your database got created with 2k or 4k db block size.
If your database got created with 2k or 4k db block size, and you attempt an upgrade from any upgrade-supported Oracle version to Oracle Database 220.127.116.11 the upgrade – regardless of DBUA or catctl.pl – will fail with an
ORA-1450: maximum key length (1478) exceeded.… [Read More]
Please find all our articles about Oracle Database Standard Edition 18.104.22.168 SE2:
- Sept 17, 2015:
SE2 – Some questions, some answers
- Sept 8, 2015:
MOS Download for Oracle SE2
- Sept 7, 2015:
Support and Patches for Oracle 22.214.171.124 SE/SE1
- Sept 3, 2015:
Can you have Multitenant with Oracle SE2?
I have blogged about the Grid Infrastructure Management Repository (GIMR) a while back:
And Markus Michalewicz, our Director of Product Management, Oracle Real Application Clusters (RAC), has published a very interesting and helpful insight article about GIMR on July 30, 2015.… [Read More]
The question sounds pretty trivial:
Which packages did exist in Oracle 126.96.36.199 but don’t exist in Oracle 188.8.131.52 anymore?
And going a bit deeper into the topic,
Which procedures and functions calls of SYS packages have been changed since then?
A colleague of mine (thanks to Thomas Kempkens from ACS Support for writing up a fancy procedure – all credits go to him) had to dig this out for a customer,
See the result.… [Read More]
Here is a new capability that might be interesting to anybody who is performing a migration using Data Pump. Previously, Data Pump would create indexes one at a time, specifying the PARALLEL keyword for the CREATE INDEX statement to invoke parallel query for index creation. We used to recommend a workaround to create indexes in parallel, which involved a three-step process of importing without indexes, then creating a SQLFILE of the CREATE INDEX statements, and breaking that file into multiple windows.… [Read More]