Query using sdo_within_distance hangs
Last updated on JANUARY 31, 2017
Applies to:Oracle Spatial and Graph - Version 220.127.116.11 and later
Microsoft Windows x64 (64-bit)
On 18.104.22.168 version, hanging issues are seen on Spatial queries using SDO_WITHIN_DISTANCE
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.
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