今日在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.csdn.net/zzvnzz/article/details/7728329
分享到:
相关推荐
NULL 博文链接:https://gembler.iteye.com/blog/346242
Patch 8922013: ORA-00600: INTERNAL ERROR CODE, ARGUMENTS: [17059], [0X93953434]
在oracle里面运行一下,解决Exception java.sql.SQLException ORA-00600 内部错误代码
ORA-00600: 内部错误代码, 参数: [kcratr_nab_less_than_odr], [1], [13], [1990],这是我自己整理的,已经试验过了
ora-01033:oracle initialization or shutdown in progress 解决方法 ora-01033:oracle initialization or shutdown in progress 解决方法 ora-01033:oracle initialization or shutdown in progress 解决方法 ora-...
在运行查询SELECT * FROM V$SESSION 会出现ORA-29275:部分多字节字符的错误,这是什么原因开始我不得其解,网上也没有介绍什么好办法。本文给出答案。
ORA-00600:internalerrorcode,arguments:[kcblasm_1],[103],[],[],[],[],[],[] TueAug1209:20:17CST2014 Errorsinfile/u01/app/oracle/admin/orcl/udump/orcl_ora_29974.trc: ORA-00600:internalerrorcode,arguments...
调整参数后引起,ORA-00838: Specified value of MEMORY_TARGET is too small, needs to be at least 3 2768M 的解决方案
ORA-32001:write to spfile requested but no spfile is in use请求写入spfile,但没有使用spfile的解决方法 在输入以下语句中报了这样的错误: SQL>alter system set control_files=’/u01/app/oracle/oradata/prod/...
ORA-12154: TNS: 无法解析指定的连接标识符的解决方法
ORA-01036:非法的变量名/编号 oracle特有的错误
ORA-00031:标记要终止的会话解决方案; ORA-00031:标记要终止的会话解决方案;
ORA-00603: ORACLE server session terminated by fatal error ORA-27504: IPC error creating OSD context ORA-27300: OS system dependent operation:sskgxp_select failed with status: 3 ORA-27301: OS ...
-- 解决ORA-00904: "WMSYS"."WM_CONCAT": 标识符无效 的文件包....... -- 解决ORA-00904: "WMSYS"."WM_CONCAT": 标识符无效 的文件包....... -- 解决ORA-00904: "WMSYS"."WM_CONCAT": 标识符无效 的文件包....... ...
oracle12c程序连接时异常: ORA-01017: 用户名/口令无效; 登录被拒绝 的解决方案。
oracle19c缺少的函数
NULL 博文链接:https://3w1h.iteye.com/blog/1211779
oracle 12 c ORA-01017: 用户名/口令无效; 登录被拒绝
oracle报错ora-12541:TNS无监听程序
错误描述:oracle远程连接服务器出现 ORA-12170 TNS:连接超时 错误检查:有很多是oracle自身安装的问题,但是我这里服务器配置正常,监听正常,服务正常,远程可以ping通服务器。 这里主要是防火墙问题,解决办法: ...