Significant Row Contention Was Detected In The Table "MDSYS.SDO_INDEX_METADATA_TABLE"
(Doc ID 953235.1)
Last updated on FEBRUARY 03, 2022
Applies to:Oracle Spatial and Graph - Version 22.214.171.124.0 and later
Information in this document applies to any platform.
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
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