My Oracle Support Banner

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.

Symptoms

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"

 

 

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.