My Oracle Support Banner

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

Last updated on APRIL 08, 2022

Applies to:

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

Symptoms

Spatial query hangs after ~ 20 minutes

select count(*) from <table1> ra, <table2> b where SDO_RELATE (b.GEOMETRY, ra.GEOMETRY,'mask=inside')='TRUE' and AHR_PK=62;

*
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

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
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.