有关 ORA-00600: internal error code, arguments: [kkqcscpopn_Int: 0] 错误,问题记录

最新推荐文章于 2024-07-15 16:24:24 发布

原创最新推荐文章于 2024-07-15 16:24:24 发布 · 642 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#数据库 #java

Oracle 同时被 2 个专栏收录

5 篇文章

订阅专栏

数据库

1 篇文章

订阅专栏

本文记录了一次遇到 Oracle 数据库 ORA-00600 错误的经历，该错误通常与内部实现细节有关。通过查询 MOS（My Oracle Support）并参考已知案例，找到了可能的解决方案，包括禁用成本基础查询转换等。

今日在Oracle控制台中看到预警中有"

意外事件

一般内部错误

. 查看日志中显示问题:

ORA-00600: internal error code, arguments: [kkqcscpopn_Int: 0], [], [], [], [], [], [], [], [], [], [], []

在Trc中也没发现具体问题.将问题发给DBA的朋友看了之后. 他在MOS中看到类似的记录.

NB Bug Fixed Description
11810296 11.2.0.3, 12.1.0.0 ORA-600 [kkqcscpopn_Int: 0] with subquery unnesting and view merging
11661678 11.2.0.3, 12.1.0.0 ORA-600 [kkqcscpopn_Int: 0] / dump from query with function based index
10242303 11.2.0.2.BP15, 11.2.0.3, 12.1.0.0 Internal errors from query with ANSI join and many columns
10184115 11.2.0.2.BP15, 11.2.0.3, 12.1.0.0 Wrong Results, Assorted Internal Errors and Dumps with ANSI join of tables with large number of columns
9324531 11.2.0.1.BP04, 11.2.0.2, 12.1.0.0 ORA-600 [kkqcscpopn_Int: 0] from ANSI query
8537544 11.2.0.2, 12.1.0.0 Excess memory use / ORA-600 / dumps parsing SQL with many nested outer joins / ANSI joins
8337618 11.2.0.1 ORA-600 [kkqcscpopn_int: 0] using complex views and GROUP BY

Description

Cost based query transformation involving combined unnest subquery and
view merging could cause ORA-600[kkqcscpopn_Int: 0]

Rediscovery Notes:
If kkqctPrepQuerySQUN() is in stack there is a chance of this bug

Workaround
Prevent Subquery Unnesting or complex view merging.
eg: Disable cost based query transformations by setting
alter system set "_optimizer_cost_based_transformation"=off

转载自：http://blog.youkuaiyun.com/zzvnzz/article/details/7728329