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 JULY 20, 2024

Applies to:

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

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