Spatial Query Using SDO_AGGR_UNION Appears to Hang
Last updated on FEBRUARY 08, 2017
Applies to:Oracle Spatial - Version: 220.127.116.11 to 10.2.0.1
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).
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