My Oracle Support Banner

Troubleshooting: "WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK! " (Doc ID 278316.1)

Last updated on MARCH 15, 2021

Applies to:

Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.

Purpose

The purpose of the note is to help troubleshoot reasons for "WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK! "

Troubleshooting Steps

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
Purpose
Troubleshooting Steps
 What is a Row Cache Enqueue Lock?
 What is the meaning of the warning WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK?
 Potential reasons for "WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK!"
 SGA Shrink/Resize Operations
 Issues by Row Cache Enqueue Type
 DC_TABLESPACES
 DC_SEQUENCES
 DC_USERS
 DC_OBJECT_IDS
 DC_SEGMENTS
 DC_ROLLBACK_SEGMENTS
 DC_TABLE_SCNS
 DC_AWR_CONTROL
 What information can be gathered to help identify the cause?
 Systemstate dump
 AWR, ADDM and ASH Reports
 How to interpret the information obtained
 Systemstate dump
 Example 1:
 Example 2:
 AWR Report
 Possible Issue in Pre-10g versions
 Troubleshooting Other Issues
References

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