Server Process Crashes ORA-07445 [kgghstfel()+ nnn] And PMON Terminated Due To ORA-00600 [17183]

(Doc ID 1448569.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.4 to 11.2.0.1 [Release 10.2 to 11.2]
Information in this document applies to any platform.

Symptoms

  1. The alert file contains reports of the following errors:

    Errors in file /oracle/smc3rptw/admin/bdump/smc3rptw_j000_16468.trc:
    ORA-07445: exception encountered: core dump [kgghstfel()+94] [SIGSEGV] [Address not mapped to object] [0x003ECE42E] [] []

    and:

    Errors in file /oracle/smc3rptw/admin/bdump/smc3rptw_pmon_25382.trc:
    ORA-00600: internal error code, arguments: [17183], [0x3FEB6CFF0], [], [], [], [], [], []

  2. The J000 trace file shows:

    *** 2012-04-07 03:54:58.786
    =================================
    Begin 4031 Diagnostic Information
    =================================
    The following information assists Oracle in diagnosing
    causes of ORA-4031 errors. This trace may be disabled
    by setting the init.ora _4031_dump_bitvec = 0
    =====================================
    Allocation Request Summary Informaton
    =====================================
    Current information setting: 04014fff
    SGA Heap Dump Interval=3600 seconds
    Dump Interval=300 seconds
    Last Dump Time=04/07/2012 03:54:58
    Dump Count=1
    Allocation request for: temporary tabl
    Heap: 4047d5f00, size: 1646096
    ******************************************************
    HEAP DUMP heap name="sga heap" desc=380000058
    extent sz=0x47c0 alt=216 het=32767 rec=9 flg=-126 opc=0
    parent=0 owner=0 nex=0 xsz=0x1
    ds for latch 1: 0x380034ff8
    reserved granule count 0 (granule size 16777216)
    ******************************************************
    HEAP DUMP heap name="temporary tabl" desc=4047d5f00
    extent sz=0x1040 alt=32767 het=32767 rec=0 flg=2 opc=0
    parent=380000058 owner=0 nex=0 xsz=0x1000000
    Subheap has 32975600 bytes of memory allocated

    with a call stack similar to:

    ... <- ksmasg <- kghnospc <- kghalf <- kxtthalo <- kgghstine <- kxttICreate <- ...

    followed by:

    *** 2012-04-07 03:55:02.364
    ksedmp: internal or fatal error
    ORA-07445: exception encountered: core dump [kgghstfel()+94] [SIGSEGV] [Address not mapped to object] [0x003ECE42E] [] []
    Current SQL statement for this session:
    grant select,insert on sys.ora_temp_1_ds_309509 to "TWROOT"
    ----- PL/SQL Call Stack -----
    object line object
    handle number name
    40099cc70 472 package body SYS.DBMS_STATS_INTERNAL
    400aeacd0 8667 package body SYS.DBMS_STATS
    400aeacd0 8752 package body SYS.DBMS_STATS
    400aeacd0 12415 package body SYS.DBMS_STATS
    400aeacd0 12892 package body SYS.DBMS_STATS
    400aeacd0 13345 package body SYS.DBMS_STATS
    400aeacd0 13457 package body SYS.DBMS_STATS
    3f68a26a8 21 procedure TWROOT.COL_TW_CORE_TBL_STATS

    with a call stack similar to:

    ... <- kgghstfel <- kxttGetEntry <- kxttGetTimestamp <- kkdlgstd <- kkmfcblo <- ...

  3. PMON crashes as a result of trying to clean up this dead process, and reports:

    *** 2012-04-07 04:05:53.494
    Process 0x40a489fe0 appears to be hung while dumping
    Current time = 3892238237, process death time = 3892173231 interval = 60000
    Attempting to kill process 0x40a489fe0 with OS pid = 16468
    OSD kill succeeded for process 40a489fe0
    *** 2012-04-07 04:06:03.705
    ********** Internal heap ERROR 17183 addr=3feb6cff0 *********

    *** 2012-04-07 04:06:04.646
    ksedmp: internal or fatal error
    ORA-00600: internal error code, arguments: [17183], [0x3FEB6CFF0], [], [], [], [], [], []

    ...
    kghfrf KGH: Non-recoverably free a freeable chunk of space.
    kxtthDrpPh
    kgghstmap kgghstmap - Hash table MAP.
    kxttClnUp
    kssxdl KSS: delete SO ignoring all except severe errors. cleans latches
    kssdch_stage
    kssdch KSS: delete children of state obj.
    ksuxds KSU: acquires the ksupol, the so latch protects access to sniper bit
    kssxdl KSS: delete SO ignoring all except severe errors. cleans latches

    with a call stack similar to:

    ... <- kghfrf <- kxtthDrpPh <- kgghstmap <- kxttClnUp <- kssxdl <- ...

Changes

A server process raised an ORA-4031 and then was terminated with an ORA-7445.

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