Spatial Merge Query Intermittently Fails with ORA-7445 [mdrjnrel()+724] (Doc ID 1666816.1)

Last updated on APRIL 28, 2014

Applies to:

Oracle Spatial and Graph - Version 11.2.0.3 to 12.1.0.1 [Release 11.2 to 12.1]
Information in this document applies to any platform.

Symptoms

A Spatial merge query intermittently fails with the following error:

merge into xxxx.xxxxxxxx
using .... sdo_join(

ORA-07445: exception encountered: core dump [mdrjnrel()+724] [SIGSEGV]

----- PL/SQL Call Stack -----
 object      line  object
 handle    number  name
46681c110        62  MDSYS.RTREEJOIN_IMP_T
46681c110        59  MDSYS.RTREEJOIN_IMP_T
477903718       470  function MDSYS.SDO_JOIN
3facdd4e0         1  anonymous block

 

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