In this Document

APPLIES TO:

SYMPTOMS

Getting the following error in the alert log from a query with more than 6 unions:

The stack trace includes all or some of the following functions:

 kkqtutlPerformSetOp <- OnList <- kkqtutlPerformSetOp <- kkqjfUnitTrans <- kkqjfpt <- kkqjfgdtr < qksqbApplyToQbcLoc <- qksqbApplyToQbcLoc <- qksqbApplyToQbc <- kkqjfdrv <- kkqdrv <- kkqctdrvIT <- apadrv <- opitca <- PGOSF634_kksFullT <- ypeCheck <- rpiswu2 <- ypeCheck <- kksLoadChild <- kxsGetRuntimeLock <- kksfbc <- kkspsc0 <- kksParseCursor <- opiosq0 <- kpooprx <- kpoal8 <- opiodr <- ttcpip <- opitsk <- opiino 

CAUSE

Bug 11846265 - ORA-00600: [KKQTSETOP.1] CAUSED BY JOIN FACTORIZATION

closed as a duplicate of:

Bug 12537316 - QBCXXSELSQ FLAG IS NOT CLEARED AFTER VIEW MERGING

where if Join Factorization is enabled ("_optimizer_force_CBQT" = "JF"), then a SET operation that contains redundant conditions in WHERE clause may return the listed ORA-600 or ORA-1790.

SOLUTION

o  Upgrade to 12.1.0.1

OR:

o  Apply 11.2.0.4 or above

OR:

o  Apply Patch 12537316 if available for your platform and Oracle version

- OR -

o Use the following workaround:

REFERENCES