Significant Row Contention Was Detected In The Table "MDSYS.SDO_INDEX_METADATA_TABLE"
Last updated on SEPTEMBER 22, 2016
Applies to:Oracle Spatial - Version 22.214.171.124.0 and later
Information in this document applies to any platform.
***Checked for relevance on 15-May-2013***
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
SQL Text begin mdsys.sdo_idx.cmt_idx_chngs('USER1', 'INDEX_OF_USER1', 'MAXDATE', 0); end;
SQL ID 4nvmz32wnr9pb
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