Drop Baselines Hangs on Library Cache Lock (文档 ID 2186647.1)
In this Document
|
|
Symptoms |
|
|
Cause |
|
|
Solution |
|
|
References |
Applies to:
Oracle Database - Enterprise Edition - Version 12.1.0.2 and laterInformation in this document applies to any platform.
Symptoms
- Drop baselines hangs with library cache lock
- If the baseline is being used, the library cache lock wait occurs. The baseline never drops.
- If the baseline is not being used, the CPU wait occurs. The baseline never drops.
- The more plans per query the longer it takes to drop. If there is only one plan, the plan drops in seconds.
Cause
This is due to following bug:
Bug 20903742 : DBMS_SPM.DROP_SQL_PLAN_BASELINE ALLOCATES HUGE AMOUNT OF PGA MEMORY
But this Bug was closed as a duplicate of following bug:
Bug 20877664 : EXTRACTCLOBXML, REPEATING PREVIOUS VALUES FOR NULL INPUT
Solution
Apply patch 20877664.
References
BUG:20903742 - DBMS_SPM.DROP_SQL_PLAN_BASELINE ALLOCATES HUGE AMOUNT OF PGA MEMORYNOTE:790039.1 - How to Drop Plans from the SQL Plan Management (SPM) Repository
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/31393455/viewspace-2130989/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
最新文章
- 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
