My Oracle Support Banner

Errors in the Alert Log: ORA-600[qerscAllocate: Buffer Size Limit[rowLen,rowCnt,bufSize]] (Doc ID 2585430.1)

Last updated on MARCH 03, 2020

Applies to:

Oracle Database - Enterprise Edition - Version 12.2.0.1 to 19.3.0.0.0 [Release 12.2 to 19]
Information in this document applies to any platform.

Symptoms

The following error occurs in the alert log:

ORA-00600: internal error code, arguments: [qerscAllocate: buffer size limit[rowLen,rowCnt,bufSize]], [136], [29686], [4037296], [], [], [], [], [], [], [], []

 

The Current SQL Statement in the associated incident trace file is a SELECT statement.

 

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

qerscAllocate <- qknRwsAllocateTree <- qknRwsAllocateTree <- qknRwsAllocateTree
 <- qknRwsAllocateTree <- qknRwsAllocateTree <- qknRwsAllocateTree
  <- qknRwsAllocateTree <- qknRwsAllocateTree <- qknRwsAllocateTree
   <- qknRwsAllocateTree <- qknDoRwsAllocate <- qkaTraverseQknDescendents
    <- qkadrv2Post <- qkadrv2 <- opitca <- kksFullTypeCheck <- rpiswu2 <- kksLoadChild
     <- kxsGetRuntimeLock <- kksfbc <- kkspbd0 <- kksParseCursor <- opiosq0 <- opipls <- opiodr
      <- rpidrus <- skgmstack <- rpidru <- rpiswu2 <- rpidrv <- psddr0 <- psdnal <- pevm_EXECC
       <- pfrinstr_EXECC <- pfrrun_no_tool <- pfrrun <- plsql_run <- peicnt <- kkxexe <- opiexe

 

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
References


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