Oracle DBMS_FIX_CONTROL_PERSISTENCE
Version 12.2.0.1

General Information
Library Note Morgan's Library Page Header
For how many years have you been working with physical servers that are starving your database of the memory necessary to deploy important new performance features such as the Result Cache, Memoptimize Pool, In-Memory Aggregation, In-Memory Column Store, and Full Database Caching? Too long? Contact me to learn how to improve all queries ... not just some queries.
Purpose This package is created to persist fix control environment and make use of the same to manage fixes which were enabled prior to applying bundle patch but got disabled as part of bundle patch.

Background: Fixes having fix_control are included in exadata bundle patches starting 11.2.0.4 BP12, these fixes are disabled by default and explicitly enabled by the customer using the dbms_optim_bundle package (note that dbms_optim_bundle does not exist in 12.2.0.1).

Issue: Fix control state for bug fixes present in the DB environment prior to bundle patch apply is not persisted after bundle patch apply.

Note: This package is dropped as of Oracle 18.0 and will be dropped from the library as of Oracle 19.
AUTHID DEFINER
Data Types  
Dependencies
ALL_OBJECTS DBMS_SYSTEM PLITBLM
DBMS_FCP_LIB DBMS_UTILITY UTL_FILE
DBMS_LOB DUAL V$INSTANCE
DBMS_OPTIM_BUGVALOBTYPE GV$INSTANCE V$PARAMETER
DBMS_OPTIM_FCTABTYPE GV$PDBS V$PDBS
DBMS_QOPATCH GV$SPPARAMETER V$SYSTEM_FIX_CONTROL
DBMS_SQLDIAG ORA_BUNDLE_FIXCONTROL_STATE$ V$SYSTEM_PARAMETER
DBMS_STANDARD ORA_FCP_PARAMS$ XMLTYPE
Documented No
First Available 12.2.0.1
Security Model Owned by SYS with no privileges granted.
Source {ORACLE_HOME}/rdbms/admin/dbmsfcp.sql
Subprograms
 
GET_DEFAULT (new 12.2)
Returns the default value of a fix_control at a given OFE dbms_fix_control_persistence.get_default(
bugno IN PLS_INTEGER,
ofe   IN PLS_INTEGER,
lvl   IN PLS_INTEGER)
RETURN PLS_INTEGER;
TBD
 
INSERT_INITIAL_DATA (new 12.2)
Inserts initial data in FCP Table. It is invoked once during feature installation as part of its post-install script. dbms_fix_control_persistence.insert_initial_data;
exec dbms_fix_control_persistence.insert_initial_data;
 
MODIFY_FCPT_ALTER_FC (new 12.2)
Modifies the modify_at_startup flag in the Fix-Control Persistence Table and then triggers an 'alter system' command to restore the required fix_controls in current environment with scope=memory. The user of this proc is the post-install script of each subsequent bundle patch which has fixes having fix_controls. dbms_fix_control_persistence.modify_FCPT_alter_FC(
startbundleId IN VARCHAR2,
endbundleId   IN VARCHAR2,
series        IN VARCHAR2,
patchMode     IN VARCHAR2,
patchId       IN VARCHAR2,
patchUID      IN VARCHAR2);
TBD
 
SYNC_FCPT_ALTER_FC (new 12.2)
Syncronizes the current fix-control environment and the fix-control persistence table. Also triggers an 'alter system' command to restore required fix_controls in the current environment with scope=memory. This is done during each database startup. User of this Procedure is qksbgnfy() which does this after the database is successfully opened. dbms_fix_control_persistence.sync_fcpt_alter_fc(performAlter IN NUMBER);
SELECT fix_control, ofe
FROM ora_bundle_fixcontrol_state$;

exec dbms_fix_control_persistence.sync_fcpt_alter_fc(42);

Related Topics
Built-in Functions
Built-in Packages
DBMS_ROLLING
What's New In 12cR2
What's New In 18cR3

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2019 Daniel A. Morgan All Rights Reserved