My Oracle Support Banner

Large Waits for 'rdbms ipc message'<='DLM cross inst call completion'<='enq: KI - contention' and SMON/CKPT waiting on 'rdbms ipc message'<='reliable message' (Doc ID 2866866.1)

Last updated on MAY 03, 2022

Applies to:

Oracle Database - Enterprise Edition - Version 19.14.0.0.0 and later
Information in this document applies to any platform.

Symptoms

In an EBS database, the database was seeing high waits on ''enq: KI - contention' and 'DLM cross inst call completion'; CKPT seemed to be hung.   The hanganalyze showed these main chains:

Chain 1:  SELECT statement waiting for many minutes on 'rdbms ipc message'<='DLM cross inst call completion'<='enq: KI - contention'.  

Chain 2:  SMON waiting on 'reliable message' and blocked by CKPT, which was waiting on 'rdbms ipc message'.

Chain 3:  Other sessions running the same SELECT statement, also waiting for 'enq: KI - contention', and noted as being blocked by Chain 1.


The short stack for the SELECT statement showed the following:

 

Changes

 The customer had recently applied a patch for unpublished Bug 33125873 - MAKE CACHE GLOBAL OBJECT INVALIDATION CIC NON-SERIALIZE FOR BETTER PERFORMANCE, and applied the 19.14 Release Update. (CIC stands for "Cross Instance Call.")

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.