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

Last updated on SEPTEMBER 22, 2016

Applies to:

Oracle Spatial - Version 11.1.0.7.0 and later
Information in this document applies to any platform.
***Checked for relevance on 15-May-2013***

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms