Query using sdo_within_distance hangs
(Doc ID 2226714.1)
Last updated on APRIL 08, 2022
Applies to:
Oracle Spatial and Graph - Version 12.1.0.2 and laterMicrosoft 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 |