Query using sdo_within_distance hangs
(Doc ID 2226714.1)
Last updated on MARCH 19, 2019
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 uses CPU.
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