Spatial Data Queries Hanging After WINDOWS DB BUNDLE PATCH 12.1.0.2.160419 Is Installed (Doc ID 2197470.1)

Last updated on OCTOBER 31, 2016

Applies to:

Oracle Spatial and Graph - Version 12.1.0.2 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.0.2 version, Query Issues

ACTUAL BEHAVIOR
---------------
Spatial query hangs after ~ 20 minutes

08:11:18 SQL> select count(*) from sdw.reliability_area ra, sdw.HV_BREAKER b where SDO_RELATE (b.GEOMETRY, ra.GEOMETRY,'mask=inside')='TRUE' and AHR_PK=62;

select count(*) from sdw.reliability_area ra, sdw.HV_BREAKER b where SDO_RELATE (b.GEOMETRY, ra.GEOMETRY,'mask=inside')='TRU
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel
Process ID: 2012
Session ID: 601 Serial number: 56185


ERROR:
ORA-03114: not connected to ORACLE


Elapsed: 00:19:25.72

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