My Oracle Support Banner

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 to [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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.