DBMS_OPTIM_BUNDLE – only available in Oracle

DBMS_OPTIM_BUNDLE - only available in Oracle DBMS_OPTIM_BUNDLE package got introduced with the April 2014 Exadata Bundle Patch. And it got introduced for all Oracle databases with the April 2017 Bundle Patch (BP). DBMS_OPTIM_BUNDLE is only available in Oracle

For more information on this package on Exadata in Oracle you may look at:

Purpose of DBMS_OPTIM_BUNDLE package in Oracle

The package got introduced to enable module bug fixes which cause an execution plan change in a disabled state.… [Read More]

Adpative Features Patches with Oracle Peoplesoft

Adaptive Feature Patches with Oracle Peoplesoft - Accenture Enkitec's ExperienceI’ve met David Kurtz, an Oracle ACE Director working for Accenture’s Enkitec division in the UK earlier this year on the OUGN Conference‘s boat trip from Oslo to Kiel and return. We set across the table at dinner. And of course we started discussing “Oracle”. David went to my talk about “How to ensure Performance Stability” before.… [Read More]

Parameter Recommendations for Oracle Database 12c – Part I

Best Practice Hint

See also:

Parameter Recommendations for Oracle Database 12c – Part II

A few weeks ago we’ve published some parameter recommendations including several underscores but based on an internal discussion (still ongoing) we decided to remove this entry and split up the tasks. The optimizer team will take over parts of it and I’ll post an update as soon as something is published.… [Read More]

PSU (and CPU/SPU) October 2015 got released

October 21, 2015 – Oracle released the October 2015 SPU/CPU, PSU and BPs.


For Oracle Database and Oracle Grid Infrastructure access the PSUs from here – if you have only a single instance database you can safely take the Combo patch as you’ll get downtime anyways – but for customers running RAC you need to evaluate the OJVM component as this will incur downtime which the database-only patch does not require as it can be applied rolling.… [Read More]

SQL Plan Management – Known Issues in Oracle

Our Support colleagues released the patch recommendation note for SQL Plan Management (SPM) for Oracle Database

SPM Note

In the unlikely event you’d like to upgrade to Oracle Database or (very very unlikely hopefully) please see these matching notes:

Some additional things to mention:

  • SPM is an Oracle Enterprise Edition feature at no extra cost
  • SPM is THE feature to ensure plan stability tackling changes such as (of course) upgrades and migrations
  • SPM has been improved a lot internally in Oracle Database
    • We now store entire plans instead of a large accumulation of hints in the SQL Management Base (SMB) in SYSAUX tablespace
    • The “Evolvetask does happen automatically (SYS_AUTO_SPM_EVOLVE_TASK) as part of the Automatic SQL Tuning Task
  • You should always adjust the retention when starting to play with SQL Plan Management as the default retention of 53 weeks may lead to a too large LOB segment in SYSAUX tablespace (and LOB segments never shrink)
    • SQL> exec DBMS_SPM.CONFIGURE(‘plan_retention_weeks’,5);
  • See the Oracle Database 12c documentation about SPM:

–Mike… [Read More]

Things to consider BEFORE upgrading to Oracle to AVOID poor performance and wrong results

Finally it got published on MyOracle Support (MOS) portal – one of the most helpful notes when we prep for an upgrade or a migration – and potentially the one with the longest title in MOS:

MOS Note: 2034610.1
Things to consider BEFORE upgrading to Oracle Database to AVOID poor performance and wrong results 

Avoid Poor Performance and Wrong Results when upgrading to

One important note regarding these “Things to Consider” notes:
They will only list issues where either a fix or a proven workaround is available.… [Read More]

DBUA 12c and “datapatch.pl” – things to know

For clarification:
The following blog post applies to upgrades to Oracle 12.1 done by DBUA only whenever a SPU/PSU/BP is installed into the 12.1 home prior to the upgrade (which I’d highly recommend as patching before upgrade saves you headache after upgrade!).

Update [Dec 10, 2015]:
The required patch is included in but not (Oct 2015) – it will be included in the (Jan 2016) and all following PSUs.
[Read More]