Oracle DBMS_FIX_CONTROL_PERSISTENCE
Version 12.2.0.1

General Information
Library Note Morgan's Library Page Header
Are you prepared for the release of Oracle Database 18c ... the first autonomous database? We are here at the Library. It is time for DBAs to stop fighting robots with their fingers and losing ... time to start using our intelligence and winning.
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.
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 12cR1
What's New In 12cR2

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-2017 Daniel A. Morgan All Rights Reserved