Disconnected sessions holding a Library Cache Lock on SYS.ALERT_QUE:HAE_SUB
(Doc ID 1266472.1)
Last updated on DECEMBER 16, 2019
Applies to:Oracle Database - Enterprise Edition - Version 10.2.0.1 to 22.214.171.124 [Release 10.2 to 11.1]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.
An OCI AQ Application using an AQ_HA_NOTIFICATION enabled service has disconnected sessions which are still registered in sys.reg$ and these sessions are involved in library cache lock contention on "SYS"."ALERT_QUE":"HAE_SUB".
More than 256 sessions are registered in sys.reg$ with the subscription name "SYS"."ALERT_QUE":"HAE_SUB"
In addition to this on shutting down the database the shutdown hangs with the pstack from the emon process generating the following stack
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document