QUERYING A MATERIALIZED VIEW RAISES ORA-00600: Internal Error Code, Arguments: [733], [402652912], [top Call Heap] (Doc ID 1457897.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1.0 to 11.2.0.3 [Release 11.2]
Information in this document applies to any platform.

Symptoms

When performing certain MVIEW operations the following error is seen :-

ORA-00600: internal error code, arguments: [733], [402652912], [top call heap], [], [], [], [], [], [], [], [], []

The call stack in the ORA-600 trace file will be similar to :=

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

     ksmarfg <- kghgex <- kghfnd <- kghalo <- kghgex
        <- kghalf <- kkqsAllocFreeableCallMem <- kkqsceut <- 
         <- kkqsckfpc <- kkqscdrv <- kkqsechk2 <- kkqsechk <- kkqspsum
          <- kkqsedrv <- kkqseqb <- kkqsrqb <- kkqsrmav <- kkqsRewriteCurrentQ
           <- kkqscqb <- kkqsptq <- kkqsptq <- kkqsptqur <- kkqsrdrv
            <- kkqdrv <- opiSem <- opiDeferredSem <- opitca <-    
              kksFullTypeCheck <- rpiswu2 <- kksLoadChild <-
                kxsGetRuntimeLock <- kksfbc <- kkspsc0
              <- kksParseCursor <- opiosq0 <- kpooprx <- kpoal8 <- opiodr
               <- ttcpip <- opitsk <- opiino <- opiodr <- opidrv
                <- sou2o <- opimai_real <- ssthrdmain <- main 
                <- libc_start_main
                 <- start



On 11201 it is possible that 600[KGHALO2] [0x0] is seen instead of ORA-600[733] and will contain a different stack trace 

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