Disconnected sessions holding a Library Cache Lock on SYS.ALERT_QUE:HAE_SUB
(Doc ID 1266472.1)
Last updated on AUGUST 04, 2018
Applies to:Oracle Database - Enterprise Edition - Version 10.2.0.1 to 18.104.22.168 [Release 10.2 to 11.1]
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