My Oracle Support Banner

ORA-07445 [smboCkaGetPivot()+176] ERROR HIT FROM VARIOUS SELECT BASED SQL (Doc ID 1624100.1)

Last updated on APRIL 06, 2020

Applies to:

Oracle Database - Standard Edition - Version 10.2.0.5 to 10.2.0.5 [Release 10.2]
Information in this document applies to any platform.

Symptoms

The following symptoms are known to be directly atrributed to this issue :-

a) Database is 10gR2

b) Error of following nature is seen in the alert log :-

ORA-07445: exception encountered: core dump [smboCkaGetPivot()+240] [SIGSEGV] [Invalid permissions for mapped object] [0x000000110] [] []

c) Stack trace will be similar to :-


Function List   (to Full stack)   (to Summary stack)

    smboCkaGetPivot <- smboCkaQS <- smboAQSdoQS <- smboAQSdoRS <- smboAQSdoQS
       <- smboSort <- smbeod <- soreod <- qersoFetch <- opifch2
        <- kpoal8 <- opiodr <- ttcpip <- opitsk <- opiino
         <- opiodr <- opidrv <- sou2o <- opimai_real <- main
          <- main_opd_entry

d) The ORA-07445 trace file will show that the EXPLAIN PLAN can be generated so this is not an EXPLAIN PLAN issue

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!


In this Document
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.