Spatial Index Deadlocks on SPATIAL_RTREE_IDX
Last updated on FEBRUARY 08, 2017
Applies to:Oracle Spatial - Version 18.104.22.168 and later
Information in this document applies to any platform.
On 22.214.171.124 when committing changes in tables with spatial indexes user session deadlocks can occur on mdsys.sdo_idx.cmt_idx_chngs('USER', 'SPATIAL_RTREE_IDX', null, 0).
Deadlocks shows up when at least two people commits changes to the same table.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms