In this Document
| | _afrLoop=1485991559877205&id=1494113.1&displayIndex=7&_afrWindowMode=0&_adf.ctrl-state=1b643objqj_756#CAUSE">Cause |
APPLIES TO:Oracle Database - Enterprise Edition - Version 11.2.0.2 to 11.2.0.3 [Release 11.2]
Information in this document applies to any platform.
SYMPTOMSGetting the following error in the alert log from a query with more than 6 unions: ORA-00600: internal error code, arguments: [kkqtSetOp.1], [], [], [], [], [], [], [], [], [], [], []
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 CAUSEBug 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. SOLUTIONo Upgrade to 12.1.0.1
OR: o Apply 11.2.0.4 or above OR:
o Apply
patchId=12537316" target="_blank">Patch 12537316 if available for your platform and Oracle version
- OR - o Use the following workaround: SQL> alter session set "_optimizer_join_factorization" = FALSE; Note:
There are some other bugs reporting the same ORA-600 and a similar call stack.
Please refer to
Note 1200522.1 - ORA-600 [kkqtSetOp.1]
which allows you to limit bug candidates based on your actual Oracle version REFERENCESNOTE:1200522.1 - ORA-600 [kkqtSetOp.1]
id=11846265">BUG:11846265 - ORA-00600: [KKQTSETOP.1] CAUSED BY JOIN FACTORIZATION
NOTE:12537316.8 - Bug 12537316 - ORA-600 / ORA-7445 for SQL with merged subquery
| 
