Managing "installed but disabled" bug fixes in Database Release Updates using DBMS_OPTIM_BUNDLE
(Doc ID 2147007.1)
Last updated on FEBRUARY 05, 2025
Applies to:
Oracle Cloud Infrastructure - Database Service - Version N/A and later Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later Oracle Database Backup Service - Version N/A and later Oracle Database - Enterprise Edition - Version 12.1.0.2 and later Oracle Database Cloud Exadata Service - Version N/A and later Information in this document applies to any platform.
Purpose
In order to support a more flexible and responsive strategy for the RDBMS software release process, Oracle Development has implemented a patch packaging technique that supports the inclusion of module bug fixes (which cause an execution plan change) in a disabled state. This technique was implemented in the April 2017 DB Proactive Bundle Patch (BP) for RDBMS 12.1.0.2. Prior to April 2017, no code module bug fixes that could have resulted in an execution plan change were considered for inclusion into BPs.
This document explains the SQL commands that are available to manage these "installed but disabled" module bug fixes (which cause an execution plan change), and the 'Automatic Fix Control Persistence' framework (needed only in 12.1.0.X) that ensures that enabled fixes are preserved during subsequent DB Proactive BP application.
Scope
This document is intended for DBA's that are responsible for RDBMS software patching.
Details
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
