Core Dump QKSWCINLINEQBC() Running DBMS_STATS (Doc ID 371462.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Server - Enterprise Edition - Version: 9.2.0.1 and later   [Release: 9.2 and later ]
Information in this document applies to any platform.

Symptoms


Got a core dump qkswcInlineQBC() running DBMS_STATS.

The trace file shows

ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [000000010175C7E8] [SIGSEGV]
[Address not mapped to object] [0x000000000] [] []
Current SQL statement for this session:
    with unqidx as
      (select /*+ rule */ cd.con#,cc.intcol#
       from sys.ccol$ cc, sys.cdef$ cd
       where 
         cc.obj# = :bobjn and cd.con# = cc.con# and cd.obj# = cc.obj# and
     cd.enabled is not null and
     cd.intcols <= :icols and cd.type# in (2,3)
       union all
       select /*+ rule */ i.obj#,ic.intcol#
       from sys.ind$ i, sys.icol$ ic
       where
         i.bo# = :bobjn and i.obj# = ic.obj# and i.intcols <= :icols and
     bitand(property,1) = 1 and bitand(flags,1025) = 0)
    select /*+ rule */ con#
    from unqidx
    where con# not in
      (select /*+ rule */ con#
       from unqidx
       where intcol# not in
             (select /*+ rule */ intcol# from icol$ where obj#=:iobjn))
----- PL/SQL Call Stack -----
object line object
handle number name
7000000ad7e0bc0 371 package body SYS.DBMS_STATS_INTERNAL
7000000addfbd18 7902 package body SYS.DBMS_STATS
7000000addfbd18 8135 package body SYS.DBMS_STATS
7000000addfbd18 10044 package body SYS.DBMS_STATS
7000000addfbd18 10553 package body SYS.DBMS_STATS
7000000addfbd18 10756 package body SYS.DBMS_STATS
7000000addfbd18 10805 package body SYS.DBMS_STATS
7000000addfbd18 10782 package body SYS.DBMS_STATS
...

 7000000b67c24b8 1 anonymous block


The Call Stack Trace in the trace file shows

qks3tAssertIDL opitca kkssbt kksfbc opiexe ...


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