ORA-600(qerghFetch:inc)错误

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

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

简单看一下SQL：

SQL> SELECT * FROM V$VERSION;

BANNERITPUB个人空间8[Pd/K-@-n&iD'Q
-----------------------------------------------------------------------ITPUB个人空间$xM!yv?7l'y}7t
Oracle Database11gEnterpriseEdition Release11.1.0.6.0 -ProductionITPUB个人空间!LNq,rO1EP
PL/SQL Release 11.1.0.6.0 - ProductionITPUB个人空间&G;F \&F"{^5e
CORE    11.1.0.6.0      ProductionITPUB个人空间!BG$YW{ c9`@Vt
TNS for Linux: Version 11.1.0.6.0 - ProductionITPUB个人空间5cYTp/X6s
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
{5V2Rs1[M+N0----------------------------------------------------------------------ITPUB个人空间J7L%O4b2[;~i9M#sq5A
EXACT

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

    MAX(0)     MAX(0)
/V-yO
Tj;h~5dv8t0---------- ----------ITPUB个人空间4I7]"B'm$F$xC
         0          0

SQL> ALTER SESSION SET CURSOR_SHARING = SIMILAR;

Session altered.

SQL> SELECT MAX(1), MAX(1) FROM T_600 GROUP BY ID;ITPUB个人空间HywgA7h
j
SELECT MAX(1), MAX(1) FROM T_600 GROUP BY ID
2og r'N6~1Z
E Gm0                                           *ITPUB个人空间'A.ru-\4msM {
ERROR at line 1:ITPUB个人空间:[*DpN+\0mxH+y4P_Fj
ORA-00600: internal error code, arguments: [qerghFetch:inc], [], [], [], [], [], [], []

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

*** 2008-05-17 08:10:01.301ITPUB个人空间IDME:h:H}H
*** SESSION ID:(135.340) 2008-05-17 08:10:01.301ITPUB个人空间!V L|mbw[4n~7AS
*** CLIENT ID:() 2008-05-17 08:10:01.301ITPUB个人空间;^
zR+G)e:~(\gA]"l
*** SERVICE NAME:(SYS$USERS) 2008-05-17 08:10:01.301
'q(kb
L9g0*** MODULE NAME:(SQL*Plus) 2008-05-17 08:10:01.301
+^ k)@T@fB/s:E0*** ACTION NAME:() 2008-05-17 08:10:01.301
'L5B!{B2_
F9^a0 
3Qa*}'? gt&LT0Dump continued from file: /data/oracle/diag/rdbms/ora11g_p/ora11g/trace/ora11g_ora_29171.trc
1O K'_4` ~H0y8z0ORA-00600: internal error code, arguments: [qerghFetch:inc], [], [], [], [], [], [], []

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

*** 2008-05-17 08:10:01.302
H8A R7v)A%K%A'f.I.k0----- Current SQL Statement for this session (sql_id=51fwv3avg0u5c) -----ITPUB个人空间i-m6H3t7|Q6Q`/Z!Lz#W
SELECT MAX(:"SYS_B_0"), MAX(:"SYS_B_1") FROM T_600 GROUP BY ID

----- Call Stack Trace -----ITPUB个人空间N"MKfz
calling              call     entry                argument values in hex     
s"H&O/a2dp3|0location             type     point                (? means dubious value)    
v x6z5[+~7nu0-------------------- -------- -------------------- ----------------------------
*T4YoM
n%Y$P_S*F0skdstdst()+38        call     kgdsdst()            BF9AA824 ? 2 ?
9F1mw/Go-JY0ksedst1()+88         call     skdstdst()           BF9AA824 ? 0 ? 1 ? A5A8A7E ?ITPUB个人空间\9O[lq"\`e
                                                   853D36A? A5A8A7E ?ITPUB个人空间1`#BXm%Bv
ksedst()+33          call     ksedst1()+8         2F673131 ?64F564 ? 2050033 ?
Pe6tgR
] |L$Ks0                                                   0 ? FF ? 2004 ?
!N7u8u!z3T0dbkedDefDump()+1046  call     ksedst()             0 ? 3 ? 0 ? 20436458 ? 0 ?ITPUB个人空间L%Yq oe\I
                                                   20436458 ?
o.P$l-V*Lqa0ksedmp()+47          call     dbkedDefDump()       3 ? 2 ?
#g*|2U0qS
o ZZ/a(K0ksfdmp()+26          call     ksedmp()             3EB ? BF9AACD8 ? D7A4082 ?ITPUB个人空间 \1o h0g^zX^[
                                                   F563360 ? 3EB ? BF9ADDBC ?

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