In this Document
|
|
Symptoms |
|
|
Changes |
|
|
Cause |
|
|
Solution |
|
|
References |
Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.4 and laterInformation in this document applies to any platform.
Symptoms
- The database hangs with 'Library Cache Lock'
-
Blocker session hangs on internal query with SQL_ID '8p7ujfdc5aycf' which causes high CPU:
SQL Text:SELECT fix_control,
ofe,
default_value
FROM sys.ora_bundle_fixcontrol_state$
WHERE modify_at_startup = 1
AND Bitand(initfile_flag, 1) = 0
AND sid = :1
Changes
None
Cause
This is due to following bug:
Bug:20228468 - TRANSPARENTLY ENABLE OPTIMIZER FOR FIXES PREVIOUSLY ENABLED BEFORE APPLYING BPDelete Reference
Solution
Apply the fix control:
ALTER SYSTEM SET _fix_control='20228468:OFF' SCOPE=BOTH SID='ukgatgxp3';