Parallel Query using MAX Function May Fail With ORA-00600 [RWORUPO.1] (Doc ID 802274.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Server - Enterprise Edition - Version: 9.2.0.1 to 10.1.0.5 - Release: 9.2 to 10.1
Information in this document applies to any platform.
***Checked for relevance on 29-Feb-2012***

Symptoms

Parallel Query fails with the following error if using MAX() function:

ORA-00600: internal error code, arguments: [rworupo.1], [89], [49], [], [], [], [], []

Example:

SELECT /*+ CIV_GB */ A1.C0,CASE A1.C1 WHEN 'SMLBUS' THEN
NVL(MAX(SYS_OP_CSR(A1.C2,0)),MAX(SYS_OP_CSR(A1.C2,1))) WHEN 'LRGBUS' THEN
NVL(MAX(SYS_OP_CSR(A1.C2,0)),MAX(SYS_OP_CSR(A1.C2,1))) WHEN 'SMEUK' THEN
NVL(MAX(SYS_OP_CSR(A1.C2,1)),MAX(SYS_OP_CSR(A1.C2,0))) WHEN 'MMUK' THEN
NVL(MAX(SYS_OP_CSR(A1.C2,1)),MAX(SYS_OP_CSR(A1.C2,0))) END FROM :Q2889166005 A1 GROUP BY
A1.C0,A1.C1

Call Stack looks like:

rworupo <- kxfqupm <- kxfqdeq <- qertqFetch <- qergsFetch <- opifch2 <- opifch
<- kxfxsfe <- kxfxse <- kxfxmai <- kxfprdp <- opirip <- opidrv <- sou2o <- main <- start


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