Spatial Query Using SDO_AGGR_UNION Appears to Hang (Doc ID 339322.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Spatial - Version: 9.2.0.5 to 10.2.0.1
Information in this document applies to any platform.

Symptoms

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).

Cause

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