发表于: 2008.06.25 23:54
分类: ORACLE , Bug
出处: http://yangtingkun.itpub.net/post/468/465048
---------------------------------------------------------------
这个错误和昨天文章中描述的错误是同一个错误,似乎只是操作系统不同,而导致报错的错误信息不同。
上一篇介绍的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]错误是同一个错误,只不过在不同操作系统下报错信息不同罢了。











