Errors in the Alert Log: ORA-600[qerscAllocate: buffer size limit]

(Doc ID 2416101.1)

Last updated on JULY 06, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
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], [], [], [], [], [], [], [], [], [], [], []

 

The Current SQL Statement in the associated incident trace file shows:

SELECT M.* FROM NEMIS.TT_MASTER_CLAIM M WHERE M.STATE = :B2 AND (SUBMITTED IS NULL OR SUBMITTED = 'NO') AND M.DATA_LEVEL IS NULL AND M.ACTION IS NULL AND M.TTID = :B1 AND M.TYPE_OF_CLAIM IN (SELECT TYPE_OF_CLAIM FROM NEMIS.TT_CLAIM_CONFIG WHERE STATE = :B2 AND SOURCE_SYSTEM = :B3 ) AND EXISTS (SELECT * FROM NEMIS.FIN_PROF_HEADER D WHERE STATE = :B2 AND M.STATE = D.STATE AND M.CLAIM_ID = D.CLAIM_ID AND M.TYPE_OF_CLAIM = D.TYPE_OF_CLAIM) AND EXISTS (SELECT * FROM NEMIS.FIN_PROF_DETAIL D WHERE STATE = :B2 AND M.STATE = D.STATE AND M.CLAIM_ID = D.CLAIM_ID AND SUB_LINE_CODE <> '01') UNION SELECT M.* FROM NEMIS.TT_MASTER_CLAIM M WHERE M.STATE = :B2 AND (SUBMITTED IS NULL OR SUBMITTED = 'NO') AND M.DATA_LEVEL IS NULL AND M.ACTION IS NULL AND M.TTID = :B1 AND M.TYPE_OF_CLAIM IN (SELECT TYPE_OF_CLAIM FROM NEMIS.TT_CLAIM_CONFIG WHERE STATE = :B2 AND SOURCE_SYSTEM = :B3 ) AND EXISTS (SELECT * FROM NEMIS.FIN_INST_HEADER D WHERE STATE = :B2 AND M.STATE = D.STATE AND M.CLAIM_ID = D.CLAIM_ID AND M.TYPE_OF_CLAIM = D.TYPE_OF_CLAIM) AND EXISTS (SELECT * FROM NEMIS.FIN_INST_DETAIL D WHERE STATE = :B2 AND M.STATE = D.STATE AND M.CLAIM_ID = D.CLAIM_ID AND SUB_LINE_CODE <> '01')

 

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

qerscAllocate <- qknRwsAllocateTree <- qknRwsAllocateTree <- qknRwsAllocateTree <- qknRwsAllocateTree <- qknRwsAllocateTree <- qknRwsAllocateTree <- qknRwsAllocateTree <- qknRwsAllocateTree <- qknDoRwsAllocate <- qkaTraverseQkn <- qkadrv2Post <- qkadrv2 <- opitca <- kksSetBindType <- kksfbc <- opiexe <- opipls <- opiodr <- rpidrus <- skgmstack <- rpiswu2 <- rpidrv <- psddr0 <- psdnal <- pevm_EXECC <- pfrinstr_EXECC <- pfrrun_no_tool <- pfrrun <- plsql_run <- peicnt <- kkxexe <- opiexe <- kpoal8 <- opiodr <- ttcpip <- opitsk <- opiino <- opiodr <- opidrv <- sou2o

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