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 22.214.171.124.0 and later
Information in this document applies to any platform.
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:
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.")
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