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
Oracle Spatial and Graph - Version 22.214.171.124 and later
Information in this document applies to any platform.
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;
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) ) ;
ORA-03114: not connected to ORACLE
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.
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.
|This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.|