The DBMS_OPTIM_BUNDLE package got introduced with the April 2014 Exadata 126.96.36.199 Bundle Patch. And it got introduced for all Oracle 188.8.131.52 databases with the April 2017 Bundle Patch (BP). DBMS_OPTIM_BUNDLE is only available in Oracle 184.108.40.206.
For more information on this package on Exadata in Oracle 220.127.116.11 you may look at:
I’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]
For Oracle Database 18.104.22.168 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]
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 22.214.171.124:
We now store entire plans instead of a large accumulation of hints in the SQL Management Base (SMB) in SYSAUX tablespace
The “Evolve” task 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)
The following blog post applies to upgrades to Oracle 12.1 done by DBUA onlywhenever 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 126.96.36.199BP13 but not 188.8.131.52.PSU5 (Oct 2015) – it will be included in the 184.108.40.206.PSU6 (Jan 2016) and all following PSUs.… [Read More]