My Oracle Support Banner

DBMS_STATS.GATHER_DATABASE_STATS causing ORA-7445[strlen()+80] (Doc ID 2422746.1)

Last updated on AUGUST 14, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

Running this statement

BEGIN DBMS_STATS.GATHER_DATABASE_STATS (gather_sys=>TRUE); END;

fails with the following error in the alert log:

ORA-07445: exception encountered: core dump [strlen()+80] [SIGSEGV] [ADDR:0x0] [PC:0xFFFFFFFF79A3C890] [Address not mapped to object] []

 

The Call Stack Trace in the associated incident trace file shows:


strlen <- lwsfdsev <- lwsfdlv
  <- lsfdlv <- lsfpv <- kudmlgf <- kudmcxSkudmioError <- kudmrb <- kudmxfe
   <- kpxsFetchDriver <- kpxsFetchField <- kpxsFetch <- qxxqFetch <- spefcpfa <- spefmccallstd
    <- pgmcetc_execute_trusted_c <- pgmccc_call_c <- pciccc_call_c <- kkxmcexe <- kgmexcb <- kgmexwi
     <- kgmexec <- evapls <- evaopn2 <- qximeop_fbk <- qxxmeop <- qerxtFetchHelper
      <- qerxtFetch <- qerandvFetch <- qergsFetch <- opifch2 <- kpoal8 <- opiodr
       <- kpoodrc <- rpiswu2 <- kpoodr <- upirtrc <- kpurcsc <- kpufch0
        <- kpufch <- qksanExecSql <- qksanAnalyzeSqlConCbk <- qksanAnalyzeSql <- qksanAnalyzeSegSql <- kestsGatherSqlStatistics
         <- kestsProcessSql <- kestsProcessSqlCallout <- spefcmpa <- spefmccallstd <- peftrusted <- psdexsp
          <- rpiswu2


The Plan Table in the same incident trace file shows:

--------------------------------------------------------------------+-----------------------------------+
| Id  | Operation                         | Name                     | Rows  | Bytes | Cost  | Time      |
---------------------------------------------------------------------+-----------------------------------+
| 0   | SELECT STATEMENT                  |                          |       |       |  4308 |           |
| 1   |  SORT AGGREGATE                   |                          |     1 |   152 |       |           |
| 2   |   OPTIMIZER STATISTICS GATHERING  |                          |  317K |   47M |  4308 |  00:00:13 |
| 3   |    EXTERNAL TABLE ACCESS FULL     | EXTERNAL_TABLE_NAME|  317K |   47M |  4308 |  00:00:13 |  -          <<<<<<-----
---------------------------------------------------------------------+-----------------------------------+

 

The Current Wait Stack in the same incident trace file shows:  "external table write"    
   

   Current Wait Stack:
         Not in wait; last wait ended 5.185013 sec ago
       Wait State:
         fixed_waits=0 flags=0x21 boundary=0x0/-1
       Session Wait History:
           elapsed time of 5.185203 sec since last wait
        0: waited for 'external table write'                                   <<<<<-----
           filectx=0xffffffff71094598, file#=0x0, size=0xc7
           wait_id=335758 seq_num=8100 snap_id=1
           wait times: snap=0.000172 sec, exc=0.000172 sec, total=0.000172 sec
           wait times: max=infinite
           wait counts: calls=0 os=0
           occurred after 0.000016 sec of elapsed time

 

Changes

 

Cause

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.