ORA-00600: internal error code, arguments: [kkqtSetOp.1]

最新推荐文章于 2021-07-21 16:11:29 发布

原创最新推荐文章于 2021-07-21 16:11:29 发布 · 5.4k 阅读

0 ·

CC 4.0 BY-SA版权

Oracle 管理专栏收录该内容

188 篇文章

订阅专栏

本文详细解释了在将数据库从32位升级到64位后，执行特定SQL语句时遇到ORA-00600内部错误的问题，并提供了升级至12.1.0.1版本、应用补丁或使用工作规避等解决方案。

新数据库从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)

转到底部

修改时间:2014-2-7

类型:PROBLEM

In this Document

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.

SYMPTOMS

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

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:

                 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

REFERENCES

NOTE:1200522.1 - ORA-600 [kkqtSetOp.1]
BUG:11846265 - ORA-00600: [KKQTSETOP.1] CAUSED BY JOIN FACTORIZATION

NOTE:12537316.8 - Bug 12537316 - ORA-600 / ORA-7445 for SQL with merged subquery