My Oracle Support Banner

Query using sdo_within_distance hangs (Doc ID 2226714.1)

Last updated on MARCH 19, 2019

Applies to:

Oracle Spatial and Graph - Version 12.1.0.2 and later
Microsoft Windows x64 (64-bit)

Symptoms

On 12.1.0.2 version, hanging issues are seen on Spatial queries using SDO_WITHIN_DISTANCE

Example
---------------
select /*+ INDEX (gtable B$LEDNING50_LN_GIDX) */ 1 from <table> gtable, <table> B where gtable.g3e_cno = 480 and B.request_number = 1156286 and B.id = 1 and sdo_within_distance(gtable.G3E_GEOMETRY, B.g3e_Geometry, 'distance=25') = 'TRUE'

the session hangs and uses CPU.

Changes

 

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
Changes
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.