新数据库从32升级到64位的11G 11 2 0 3

有条SQL 语句运行的时候会导致内部错误. 使用PL/SQL DEVELOPER 查询该语句的运行机会 按F5键 就激发了这个ORA600

单击此项可加入到收藏夹

Query fails with ORA-00600: internal error code, arguments: [kkqtSetOp.1] (文档 ID 1494113.1)

_afrLoop=1485991559877205&id=1494113.1&displayIndex=7&_afrWindowMode=0&_adf.ctrl-state=1b643objqj_756#" style="font-size: 11px; white-space: nowrap; text-decoration: none; ">转究竟部

---

改动时间:2014-2-7类型:PROBLEM

为此文档评级

_afrLoop=1485991559877205&id=1494113.1&displayIndex=7&_afrWindowMode=0&_adf.ctrl-state=1b643objqj_756#" style="font-size: 11px; white-space: nowrap; text-decoration: none; ">通过电子邮件发送此文档的链接

id=1494113.1" target="_blank" style="font-size: 11px; white-space: nowrap; text-decoration: none; ">在新窗体中打开文档

In this Document

Symptoms

 

_afrLoop=1485991559877205&id=1494113.1&displayIndex=7&_afrWindowMode=0&_adf.ctrl-state=1b643objqj_756#CAUSE">Cause

 

Solution

 

References

---

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.

Getting 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

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.

o  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

NOTE: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

 

 

相关内容

 

 

 

• Oracle Database Products > Oracle Database Suite > Oracle Database > Oracle Database - Enterprise Edition > 

  operation=doSearch&task=SearchProduct&type=component&id=CI_3_3WTTGSQ&prodid=PI_1_97NVP&name=Internals%20Errors%20(ORA-600%20&%20ORA-7445)&source=" target="_parent" style="font-size: 11px; color: rgb(0, 50, 134); text-decoration: none; ">Internals Errors (ORA-600 & ORA-7445) > 

  operation=doSearch&task=SearchProduct&type=subcomponent&id=SCI_3_2OYS_5933&prodid=PI_1_97NVP&comp=CI_3_3WTTGSQ&name=Performance&source=" target="_parent" style="font-size: 11px; color: rgb(0, 50, 134); text-decoration: none; ">Performance

operation=doSearch&term=ORA-00600%3A%20%5BKKQTSETOP.1%5D&error=true&task=error&source=" target="_parent" style="text-decoration: none; color: rgb(0, 113, 194); cursor: text; padding-top: 5px; ">ORA-00600: [KKQTSETOP.1];ORA-1790