My Oracle Support Banner

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

Last updated on DECEMBER 01, 2016

Applies to:

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


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:
.... 1 rows with spatial data in column GEOM
Spatial Indexes:
.... This index does not have a VALID row in MDSYS.SDO_GEOM_METADATA_TABLE

Error is reproducible when gathering statistics for the table:


To view full details, 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 a vibrant support community of peers and Oracle experts.