Query using sdo_within_distance hangs (Doc ID 2226714.1)

Last updated on JANUARY 31, 2017

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 burns CPU.




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