My Oracle Support Banner

Significant Row Contention Was Detected In The Table "MDSYS.SDO_INDEX_METADATA_TABLE" (Doc ID 953235.1)

Last updated on JANUARY 16, 2024

Applies to:

Oracle Spatial and Graph - Version 11.1.0.7.0 and later
Information in this document applies to any platform.Symptoms

Enterprise Manager ADDM reports the following message:

Significant row contention was detected in the TABLE "MDSYS. SDO_INDEX_METADATA_TABLE" with object id 45216. Trace the cause of row contention in the application logic using the given blocked SQL. Database Object MDSYS.SDO_INDEX_METADATA_TABLE

Rationale The SQL statement with SQL_ID "4nvmz32wnr9pb" was blocked on row
locks.
SQL Text begin mdsys.sdo_idx.cmt_idx_chngs('USER1', 'INDEX_OF_USER1', 'MAXDATE', 0); end;
SQL ID 4nvmz32wnr9pb

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
Cause
Solution

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