Hang with Library Cache Lock and Blocker is Internal Query SQL 8p7ujfdc5aycf

mosdoc發表於2016-12-19
BloCSQL
Database Hangs with 'Library Cache Lock' and the Blocker is Due Internal Query with SQL_ID '8p7ujfdc5aycf' (文件 ID 2192624.1)

In this Document


Symptoms

Changes

Cause

Solution

References


Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.4 and later
Information 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:

- 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部落格 ” ，連結：http://blog.itpub.net/31393455/viewspace-2130988/，如需轉載，請註明出處，否則將追究法律責任。

相關文章