错误信息如下：

Errors in file /opt/oracle/admin/data01/udump/data01_ora_3675.trc:
ORA-00600: internal error code, arguments: [17182], [0xFFFFFFFF7CC71DE8], [], [], [], [], [], []
Wed May 28 15:12:09 2008
Errors in file /opt/oracle/admin/data01/udump/data01_ora_3675.trc:
ORA-00600: internal error code, arguments: [kghasp1], [0xFFFFFFFF7CC71DC0], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [17182], [0xFFFFFFFF7CC71DE8], [], [], [], [], [], []
Wed May 28 15:12:10 2008
Errors in file /opt/oracle/admin/data01/udump/data01_ora_3675.trc:
ORA-00600: internal error code, arguments: [kghasp1], [0xFFFFFFFF7CC71DC0], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kghasp1], [0xFFFFFFFF7CC71DC0], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [17182], [0xFFFFFFFF7CC71DE8], [], [], [], [], [], []
Wed May 28 15:12:12 2008
Errors in file /opt/oracle/admin/data01/udump/data01_ora_3675.trc:
ORA-00600: internal error code, arguments: [kghasp1], [0xFFFFFFFF7CC71DC0], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kghasp1], [0xFFFFFFFF7CC71DC0], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kghasp1], [0xFFFFFFFF7CC71DC0], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [17182], [0xFFFFFFFF7CC71DE8], [], [], [], [], [], []
Wed May 28 15:12:15 2008
Errors in file /opt/oracle/admin/data01/udump/data01_ora_3675.trc:
ORA-00600: internal error code, arguments: [kghasp1], [0xFFFFFFFF7CC71DC0], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kghasp1], [0xFFFFFFFF7CC71DC0], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kghasp1], [0xFFFFFFFF7CC71DC0], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kghasp1], [0xFFFFFFFF7CC71DC0], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [17182], [0xFFFFFFFF7CC71DE8], [], [], [], [], [], []
Wed May 28 15:12:18 2008
Errors in file /opt/oracle/admin/data01/udump/data01_ora_3675.trc:
ORA-00600: internal error code, arguments: [kghasp1], [0xFFFFFFFF7CC71DC0], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kghasp1], [0xFFFFFFFF7CC71DC0], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kghasp1], [0xFFFFFFFF7CC71DC0], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kghasp1], [0xFFFFFFFF7CC71DC0], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kghasp1], [0xFFFFFFFF7CC71DC0], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [17182], [0xFFFFFFFF7CC71DE8], [], [], [], [], [], []
Wed May 28 15:12:21 2008
Errors in file /opt/oracle/admin/data01/udump/data01_ora_3675.trc:
ORA-00600: internal error code, arguments: [kghasp1], [0xFFFFFFFF7CC71DC0], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kghasp1], [0xFFFFFFFF7CC71DC0], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kghasp1], [0xFFFFFFFF7CC71DC0], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kghasp1], [0xFFFFFFFF7CC71DC0], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kghasp1], [0xFFFFFFFF7CC71DC0], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kghasp1], [0xFFFFFFFF7CC71DC0], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [17182], [0xFFFFFFFF7CC71DE8], [], [], [], [], [], []
Wed May 28 15:12:24 2008
Errors in file /opt/oracle/admin/data01/udump/data01_ora_3675.trc:
ORA-00600: internal error code, arguments: [kghasp1], [0xFFFFFFFF7CC71DC0], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kghasp1], [0xFFFFFFFF7CC71DC0], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kghasp1], [0xFFFFFFFF7CC71DC0], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kghasp1], [0xFFFFFFFF7CC71DC0], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kghasp1], [0xFFFFFFFF7CC71DC0], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kghasp1], [0xFFFFFFFF7CC71DC0], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kghasp1], [0xFFFFFFFF7CC71DC0], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [17182], [0xFFFFFFFF7CC71DE8], [], [], [], [], [], []

而对应的trace文件中的部分信息如下：

*** 2008-05-28 15:12:07.707
*** SESSION ID:(67.16693) 2008-05-28 15:12:07.689
********** Internal heap ERROR 17182 addr=ffffffff7cc71de8 *********
***** Dump of memory around addr ffffffff7cc71de8:
FFFFFFFF7CC71BE0                   00000000 00000000          [........]
FFFFFFFF7CC71BF0 00000000 00000000 00000000 00000000  [................]
        Repeat 62 times
FFFFFFFF7CC71FE0 00000000 00000000                    [........]       
******************************************************
HEAP DUMP heap name="hash-join subh"  desc=ffffffff7cfe7d38
 extent sz=0xfefc alt=32767 het=32767 rec=0 flg=2 pc=2
 parent=ffffffff7d07ad78 wner=0 nex=0 xsz=0x3e228
EXTENT 0 addr=ffffffff7cc71dd8
ERROR extent at ffffffff7cc71dd8 contains wrong ds 0
***** Dump of memory around addr ffffffff7cc71dd8:
FFFFFFFF7CC71BD0                   00000000 00000000          [........]
FFFFFFFF7CC71BE0 00000000 00000000 00000000 00000000  [................]
        Repeat 62 times
FFFFFFFF7CC71FD0 00000000 00000000                    [........]       
  Chunk ffffffff7cc71de8 sz=        0  ERROR, BAD MAGIC NUMBER (0)
Total heap size    =        0
FREE LISTS:
 Bucket 0 size=0
  Chunk ffffffff7cb90110 sz=    11832    free      "               "
  Chunk ffffffff7cb80110 sz=    16040    free      "               "
  Chunk ffffffff7cb72070 sz=     8008    free      "               "
Total free space   =    35880
UNPINNED RECREATABLE CHUNKS (lru first):
PERMANENT CHUNKS:
  Chunk ffffffff7cb70128 sz=     8008    perm      "perm           "  alo=8008
Permanent space    =     8008
******************************************************
 Hla: 0
*** 2008-05-28 15:12:07.720
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [17182], [0xFFFFFFFF7CC71DE8], [], [], [], [], [], []
Current SQL statement for this session:
select count(*) from (select  /*+ full(i) */  a.member_type,a.ASSOCIATE_FLAG, a.wrap_code,a.wrap_desc,b.ready_flag,a.id, a.id as pro
duct_id,a.PLAT_ID,a.trade_name,b.spec,a.check_flag,  b.name_chn as drug_name,c.name as factory_name,c.abbr as factory_easy, d.code a
s doseCode, d.name_chn as doseName,a.middle_stand_rate,a.big_middle_rate,b.stand_rate,a.national_retail_price, e.name_chn as METRIC_
NAME,f.QUALITY_NAME,g.PLAT_NAME,g.plat_father,i.name ,a.url  , decode(sign(a.EXPIRY_DATE-sysdate),1,1,-1,-1,0,0) expiry_flag , decod
e(sign(a.IMPORT_LICENCE_EXPIRY_DATE-sysdate),1,1,-1,-1,0,0) import_flag  ,a.patent_flag,a.PATENT_BEGIN_DATE  ,decode(sign(a.PATENT_E
ND_DATE-sysdate),1,'1',-1,'-1',0,'0') PATENT_END_DATE  from cat_product a,cat_drug b,cat_org c, cat_doseage_form. d,cat_metric e,cat_
quality_define f,plt_plat g,gpo_usr_user i ,cat_drug b18 , cat_product_center j , cat_drug b16  ,cat_zone_product_ready r        whe
re a.medical_id = b.id  and a.check_user = i.id(+) and a.ENABLE_FLAG = '1'  and a.id=j.id   and b.code18_id = b18.id  and b.code16_i
d = b16.id      and b.ready_flag = r.ready_type(+)         and (r.plat_id ='DATA10000000000012050665'  and r.enable_flag='1' or b.re
ady_flag is null)  and  ( a.trade_name like '%炎琥宁%' or b.name_chn like :1 ) and c.name||c.abbr like :2  and a.manufacture_id = c.
id  and d.code = b.doseage_form_code and a.metric_id = e.id and a.QUALITY_CODE = f.quality_code and a.PLAT_ID = g.id )
----- Call Stack Trace -----
calling              call     entry                argument values in hex     
location             type     point                (? means dubious value)    
-------------------- -------- -------------------- ----------------------------
ksedmp()+328         CALL     ksedst()+0           FFFFFFFF7FFFA2F0 ?
                                                   000000000 ? 000000000 ?
                                                   00000003E ?
                                                   FFFFFFFF7FFFAB88 ?
                                                   1031D6908 ?
kgeriv()+208         PTR_CALL 0000000000000000     000000000 ? 000103400 ?
                                                   0001035DA ? 000102C00 ?
                                                   1035DA000 ? 1035DAE28 ?
kgesiv()+108         CALL     kgeriv()+0           1035DB088 ? 1036FCAE8 ?
                                                   000000258 ? 0000013C8 ?
                                                   FFFFFFFF7FFFB4C8 ?
                                                   1035DC458 ?
kgesic1()+32         CALL     kgesiv()+0           1035DB088 ? 1036FCAE8 ?
                                                   00000431E ? 000000001 ?
                                                   FFFFFFFF7FFFB4C8 ?
                                                   102BE7C20 ?
kghfrf()+908         CALL     kgherror()+0         1035DB088 ? 1036FCAE8 ?
                                                   00000431E ? 000000002 ?
                                                   FFFFFFFF7CC71DE8 ?
                                                   10059A300 ?
kllcqf()+232         PTR_CALL 0000000000000000     1035DB088 ?

SQL本身没有什么大问题，看来应该是Oracle本身的bug造成的。查询了一下metalink，在Doc ID:  Note:34779.1文档中，Oracle描述了这个bug的产生原因：由于Oracle检查到内存中的chunk头被覆盖，因此引发了这个错误。

检查已知的bug列表，没有发现和当前错误相似的bug。根据ORA-600 17182和kghasp1为关键字查询，结果发现问题和Bug No. 3492310的描述比较类似。

首先版本比较接近，而且数据库的平台一致，错误的调用函数列表相似度也很高。不过这个bug并没有给出错误的原因和描述，只是提到了当数据库版本升级到9205后问题没有再现。

这个错误并非第一次出现，而且每次出现时SQL基本上比较类似，但是又不是100%可重现的，估计是特定环境下导致了内存处理出现了问题。

基本上这个错误对系统的影响不大，出现的频率也很低，不过倒是可以记录一下，看看以后升级到9205以上的版本是否这个错误不会再出现。