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:
Oracle Database - Enterprise Edition - Version 19.14.0.0.0 and laterInformation 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 |