Disconnected sessions holding a Library Cache Lock on SYS.ALERT_QUE:HAE_SUB
Last updated on FEBRUARY 09, 2015
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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms