High Waits For "Channel Operations Parent Latch" Childlatch when Listening on Advancing Queueing Queues
(Doc ID 790617.1)
Last updated on FEBRUARY 01, 2022
Applies to:Oracle Database - Enterprise Edition - Version 10.2.0.1 to 10.2.0.4 [Release 10.2]
Oracle Database - Enterprise Edition - Version 126.96.36.199 to 188.8.131.52 [Release 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
Information in this document applies to any platform.
An Advanced Queueing application is being used and there are multiple sessions performing Listen operations on single and multiple-consumer queues.
Running AWR report shows a very high number of "latch free" waits.
At certain periods of time there is very heavy contention for a particular "channel operations parent latch" (child#=59). This latch is associated with the "AQ post/wait channel 1" broadcast channel.
An AWR snapshot of latch locations shows:
|channel operations parent latch||ksrchreset()||0||442,410||72,469|
An example stack from a waiting session is
kwqilintl -> kwqidlisten -> ksrchreset -> ksrmfree -> kslgetsl
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