DB Hung Due To Enq: SQ - Contention And Channel Operations Parent Latch
(Doc ID 2579560.1)
Last updated on AUGUST 23, 2019
Applies to:Oracle Database - Enterprise Edition - Version 10.2.0.4 to 10.2.0.4 [Release 10.2]
Information in this document applies to any platform.
On : 10.2.0.4 version, Real Application Cluster
Database hung due to enq: SQ - contention in RAC, LCK0 process waited for "latch free" a lot.
AWR shows that "channel operations parent latch" is the most severe "latch free", and ksrchdelete() is the top location of "channel operations parent latch"
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