ORA-07445 [mdexoCollectStatistics()+3696] [SIGILL] During Statistics Collection

(Doc ID 2385046.1)

Last updated on APRIL 11, 2018

Applies to:

Oracle Spatial and Graph - Version 12.2.0.1 and later
IBM AIX on POWER Systems (64-bit)

Symptoms

On AIX, an ORA-07445[mdexoCollectStatistics()+3696] is generated during the scheduled maintenance window for statistics collection. The same error is generated when trying to validate the structure of a table that has a spatial index.

The incident trace file shows the current SQL is:

begin :retval := "MDSYS"."SDO_STATISTICS".ODCIStatsCollect(:idx_info,:stat_opt,:stats,:env); end;

And the call stack is:

sslssSynchHdlr <- sslsshandler <- __sighandler <- mdexoCollectStatistics
<- mdexoStatsColl <- spefcpfa <- spefmccallstd <- pextproc <- peftrusted <- psdexsp

Changes

 

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