Spatial Query Using SDO_AGGR_UNION Appears to Hang
(Doc ID 339322.1)
Last updated on DECEMBER 08, 2019
Applies to:Oracle Spatial and Graph - Version 184.108.40.206 to 10.2.0.1 [Release 9.2 to 10.2]
Information in this document applies to any platform.
A query using SDO_AGGR_UNION() to aggegrate the geometries returned by a query across a large set of data may run for a very long time, or appear not to complete. Also, if the session is killed in the database, the session process may persist for some time and have to be killed at the OS level too.
The data being used is geodetic in nature (e.g SRID 8307).
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