ORA-7445 [mdexoSplitBkts] during statistics collection (Doc ID 1927706.1)

Last updated on DECEMBER 01, 2016

Applies to:

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

Symptoms

During statistics collection, an error is logged in alert_<sid>.log:

Fri Sep 12 15:54:12 2014
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x2AA91F220] [PC:0x10943DDE4, mdexoSplitBkts()+452] [flags: 0x0, count: 1]
Errors in file /ora/u01/oracle/P376/trace/diag/rdbms/p376/P376/trace/P376_ora_11993098.trc  (incident=47073):
ORA-07445: Exception aufgetreten: CORE Dump [mdexoSplitBkts()+452] [SIGSEGV] [ADDR:0x2AA91F220] [PC:0x10943DDE4] [Address not mapped to object] []
Incident details in: /ora/u01/oracle/P376/trace/diag/rdbms/p376/P376/incident/incdir_47073/P376_ora_11993098_i47073.trc

Incident trace file shows:

----- Current SQL Statement for this session (sql_id=a5bsa9wxc0u9q) -----
begin :retval := "MDSYS"."SDO_STATISTICS".ODCIStatsCollect(:idx_info,:stat_opt,:stats,:env); end;


The output from the Oracle Locator / Oracle Spatial Health Check script shows:

*************************************************************************
Tables with Spatial Columns:
*************************************************************************
<snip>
.
.. SDOTEST.COLA_MARKETS has
.... 1 rows with spatial data in column GEOM
.
**************************************************************************
Spatial Indexes:
**************************************************************************
<snip>
.
.. SDOTEST.COLA_SDO_IDX is VALID
.... This index does not have a VALID row in MDSYS.SDO_GEOM_METADATA_TABLE
.
**************************************************************************



Error is reproducible when gathering statistics for the table:

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