yangtingkun
===========================================================
ORA-600(qerghFetch:inc)错误
===========================================================

这个错误和昨天文章中描述的错误是同一个错误,似乎只是操作系统不同,而导致报错的错误信息不同。

上一篇介绍的ORA-600 [15851]错误:http://yangtingkun.itpub.net/post/468/464968


简单看一下SQL

SQL> SELECT * FROM V$VERSION;

BANNER
-----------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 -
Production PL/SQL Release 11.1.0.6.0 - Production
CORE 11.1.0.6.0 Production
TNS for Linux: Version 11.1.0.6.0 - Production
NLSRTL Version 11.1.0.6.0 - Production

SQL> CREATE TABLE T_600 (ID NUMBER);

Table created.

SQL> INSERT INTO T_600 VALUES (1);

1 row created.

SQL> COMMIT;

Commit complete.

SQL> SELECT VALUE FROM V$PARAMETER WHERE NAME = 'cursor_sharing';

VALUE
----------------------------------------------------------------------
EXACT

SQL> SELECT MAX(0), MAX(0) FROM T_600 GROUP BY ID;

MAX(0) MAX(0)
---------- ----------
0 0

SQL> ALTER SESSION SET CURSOR_SHARING = SIMILAR;

Session altered.

SQL> SELECT MAX(1), MAX(1) FROM T_600 GROUP BY ID;
SELECT MAX(1), MAX(1) FROM T_600 GROUP BY ID
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [qerghFetch:inc], [], [], [], [], [], [], []

检查对应的trace文件可以看到Oracle转变后的错误SQL

*** 2008-05-17 08:10:01.301
*** SESSION ID:(135.340) 2008-05-17 08:10:01.301
*** CLIENT ID:() 2008-05-17 08:10:01.301
*** SERVICE NAME:(SYS$USERS) 2008-05-17 08:10:01.301
*** MODULE NAME:(SQL*Plus) 2008-05-17 08:10:01.301
*** ACTION NAME:() 2008-05-17 08:10:01.301

Dump continued from file: /data/oracle/diag/rdbms/ora11g_p/ora11g/trace/ora11g_ora_29171.trc
ORA-00600: internal error code, arguments: [qerghFetch:inc], [], [], [], [], [], [], []

========= Dump for incident 156366 (ORA 600 [qerghFetch:inc]) ========

*** 2008-05-17 08:10:01.302
----- Current SQL Statement for this session (sql_id=51fwv3avg0u5c) -----
SELECT MAX(:"SYS_B_0"), MAX(:"SYS_B_1") FROM T_600 GROUP BY ID

----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
skdstdst()+38 call kgdsdst() BF9AA824 ? 2 ?
ksedst1()+88 call skdstdst() BF9AA824 ? 0 ? 1 ? A5A8A7E ?
853D36A ? A5A8A7E ?
ksedst()+33 call ksedst1()+8 2F673131 ? 64F564 ? 2050033 ?
0 ? FF ? 2004 ?
dbkedDefDump()+1046 call ksedst() 0 ? 3 ? 0 ? 20436458 ? 0 ?
20436458 ?
ksedmp()+47 call dbkedDefDump() 3 ? 2 ?
ksfdmp()+26 call ksedmp() 3EB ? BF9AACD8 ? D7A4082 ?
F563360 ? 3EB ? BF9ADDBC ?

根据METALINK文档Doc ID: Note:463410.1的说明,这个bug和前一篇描述的ORA-600 [15851]错误是同一个错误,只不过在不同操作系统下报错信息不同罢了。

yangtingkun 发表于:2008.06.25 23:54 ::分类: ( ORACLE , Bug ) ::阅读:(127次) :: 评论 (0)

发表评论
标题

在此添加评论
表情符号: smile laughing tongue angry crying sad wassat wink

称呼

邮箱地址(可选)

个人主页(可选)

 authimage


切换风格
新闻聚合
博客日历
文章归档...
最新发表...
最新评论...
最多阅读文章...
最多评论文章...
博客统计...
Blog信息
网站链接...