Hang with Library Cache Lock and Blocker is Internal Query SQL 8p7ujfdc5aycf
Database Hangs with 'Library Cache Lock' and the Blocker is Due Internal Query with SQL_ID '8p7ujfdc5aycf' (文档 ID 2192624.1)
Information in this document applies to any platform.
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';
References
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/31393455/viewspace-2130988/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
最新文章
- How to Match a Row Cache Object Child Latch to its Row Cache
- WAITEVENT: "latch: row cache objects" Reference Note (Doc ID 1550722.1)
- Resolving Issues Where 'Row Cache Lock' Waits are Occurring
- WAITEVENT: "row cache lock" Reference Note (文档 ID 34609.1)
- DataPump Export/Import Of LOBs Are Not Executed in Parallel
- How To Move DB To Different Diskgroup/Change Diskgroup Redundancy
- Oracle DB OS Install and Configure Requirements Quick Reference (8.0.5 to 11.2)
- Oracle DB OS Install and Configure Requirements Quick Reference (12.1)
- In V$SESSION, column SQL_ID is not NULL while STATUS is INACTIVE
- SQL: How to Find Sessions Generating Lots of Redo or Archive logs
