SDO_AGGR_SET_UNION Results in ORA-03113 when Spatial_vector_acceleration is Set to True in 12c (Doc ID 1644496.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Spatial and Graph - Version 12.1.0.1 and later
Information in this document applies to any platform.

Symptoms

Getting ORA-03113 errors when aggregating geometries when the SPATIAL_VECTOR_ACCELERATION parameter is set
to TRUE, e.g.-

alter session set spatial_vector_acceleration = true;
declare
shapes  mdsys.sdo_geometry_array;
shape   mdsys.sdo_geometry;
begin
select z.geom bulk collect into shapes from spatial_bug.some_zips z ;
shape := sdo_aggr_set_union( shapes, 0.5 );
dbms_output.put_line( sdo_util.GetNumVertices( shape) ) ;
end;
/

Output =>
 
ERROR:
ORA-03114: not connected to ORACLE

declare
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel
Process ID: 2344
Session ID: 1026 Serial number: 335
 
Alert.log shows -

Mon Nov 04 15:46:40 2013
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x1153544143]
[PC:0xB86D785, kohfrr()+149] [flags: 0x0, count: 1]

When SPATIAL_VECTOR_ACCELERATION parameter is set to FALSE, the sdo_aggr_set_union completes successfully.

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