ORA-07445 [mdexoCollectStatistics()+3696] [SIGILL] During Statistics Collection
Last updated on APRIL 11, 2018
Applies to:
Oracle Spatial and Graph - Version 12.2.0.1 and laterIBM 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
<- 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