在客户的Oracle 9204 RAC for Linux x86环境中，发现同一SQL引发了多个ORA-7445错误。
节点1上错误信息为：
Wed Nov 30 14:19:38 2011 Errors IN file /u01/oracle/admin/oric/udump/oric1_ora_8519.trc: ORA-07445: exception encountered: core dump [kghalf()+743] [SIGSEGV] [Address NOT mapped TO object] [0x1FE0] [] [] . . . Thu DEC 1 16:09:03 2011 Errors IN file /u01/oracle/admin/oric/udump/oric1_ora_8493.trc: ORA-07445: exception encountered: core dump [smbput()+10979] [SIGSEGV] [Address NOT mapped TO object] [0x31303200] [] [] Thu DEC 1 16:09:03 2011 Errors IN file /u01/oracle/admin/oric/udump/oric1_ora_8493.trc: ORA-00600: internal error code, arguments: [kghasp1], [0x4FA21E38], [], [], [], [], [], [] ORA-07445: exception encountered: core dump [smbput()+10979] [SIGSEGV] [Address NOT mapped TO object] [0x31303200] [] [] Thu DEC 1 16:09:04 2011 Errors IN file /u01/oracle/admin/oric/udump/oric1_ora_8493.trc: ORA-00600: internal error code, arguments: [kghasp1], [0x4FA21E38], [], [], [], [], [], [] ORA-00600: internal error code, arguments: [kghasp1], [0x4FA21E38], [], [], [], [], [], [] ORA-07445: exception encountered: core dump [smbput()+10979] [SIGSEGV] [Address NOT mapped TO object] [0x31303200] [] [] Thu DEC 1 16:09:04 2011 Errors IN file /u01/oracle/admin/oric/udump/oric1_ora_8493.trc: ORA-00600: internal error code, arguments: [kghasp1], [0x4FA21E38], [], [], [], [], [], [] ORA-00600: internal error code, arguments: [kghasp1], [0x4FA21E38], [], [], [], [], [], [] ORA-00600: internal error code, arguments: [kghasp1], [0x4FA21E38], [], [], [], [], [], [] ORA-07445: exception encountered: core dump [smbput()+10979] [SIGSEGV] [Address NOT mapped TO object] [0x31303200] [] [] Thu DEC 1 16:09:05 2011 Errors IN file /u01/oracle/admin/oric/udump/oric1_ora_8493.trc: ORA-00600: internal error code, arguments: [kghasp1], [0x4FA21E38], [], [], [], [], [], [] ORA-00600: internal error code, arguments: [kghasp1], [0x4FA21E38], [], [], [], [], [], [] ORA-00600: internal error code, arguments: [kghasp1], [0x4FA21E38], [], [], [], [], [], [] ORA-00600: internal error code, arguments: [kghasp1], [0x4FA21E38], [], [], [], [], [], [] ORA-07445: exception encountered: core dump [smbput()+10979] [SIGSEGV] [Address NOT mapped TO object] [0x31303200] [] [] Thu DEC 1 16:09:05 2011 Errors IN file /u01/oracle/admin/oric/udump/oric1_ora_8493.trc: ORA-00600: internal error code, arguments: [kghasp1], [0x4FA21E38], [], [], [], [], [], [] ORA-00600: internal error code, arguments: [kghasp1], [0x4FA21E38], [], [], [], [], [], [] ORA-00600: internal error code, arguments: [kghasp1], [0x4FA21E38], [], [], [], [], [], [] ORA-00600: internal error code, arguments: [kghasp1], [0x4FA21E38], [], [], [], [], [], [] ORA-00600: internal error code, arguments: [kghasp1], [0x4FA21E38], [], [], [], [], [], [] ORA-07445: exception encountered: core dump [smbput()+10979] [SIGSEGV] [Address NOT mapped TO object] [0x31303200] [] [] Thu DEC 1 16:09:06 2011 Errors IN file /u01/oracle/admin/oric/udump/oric1_ora_8493.trc: ORA-00600: internal error code, arguments: [kghasp1], [0x4FA21E38], [], [], [], [], [], [] ORA-00600: internal error code, arguments: [kghasp1], [0x4FA21E38], [], [], [], [], [], [] ORA-00600: internal error code, arguments: [kghasp1], [0x4FA21E38], [], [], [], [], [], [] ORA-00600: internal error code, arguments: [kghasp1], [0x4FA21E38], [], [], [], [], [], [] ORA-00600: internal error code, arguments: [kghasp1], [0x4FA21E38], [], [], [], [], [], [] ORA-00600: internal error code, arguments: [kghasp1], [0x4FA21E38], [], [], [], [], [], [] ORA-07445: exception encountered: core dump [smbput()+10979] [SIGSEGV] [Address NOT mapped TO object] [0x31303200] [] [] Thu DEC 1 16:09:08 2011 Errors IN file /u01/oracle/admin/oric/udump/oric1_ora_8493.trc: ORA-00600: internal error code, arguments: [kghasp1], [0x4FA21E38], [], [], [], [], [], [] ORA-00600: internal error code, arguments: [kghasp1], [0x4FA21E38], [], [], [], [], [], [] ORA-00600: internal error code, arguments: [kghasp1], [0x4FA21E38], [], [], [], [], [], [] ORA-00600: internal error code, arguments: [kghasp1], [0x4FA21E38], [], [], [], [], [], [] ORA-00600: internal error code, arguments: [kghasp1], [0x4FA21E38], [], [], [], [], [], [] ORA-00600: internal error code, arguments: [kghasp1], [0x4FA21E38], [], [], [], [], [], [] ORA-00600: internal error code, arguments: [kghasp1], [0x4FA21E38], [], [], [], [], [], [] ORA-07445: exception encountered: core dump [smbput()+10979] [SIGSEGV] [Address NOT mapped TO object] [0x31303200] [] [] Thu DEC 1 16:09:09 2011 Errors IN file /u01/oracle/admin/oric/udump/oric1_ora_8493.trc: ORA-00600: internal error code, arguments: [kghasp1], [0x4FA21E38], [], [], [], [], [], [] ORA-00600: internal error code, arguments: [kghasp1], [0x4FA21E38], [], [], [], [], [], [] ORA-00600: internal error code, arguments: [kghasp1], [0x4FA21E38], [], [], [], [], [], [] ORA-00600: internal error code, arguments: [kghasp1], [0x4FA21E38], [], [], [], [], [], [] ORA-00600: internal error code, arguments: [kghasp1], [0x4FA21E38], [], [], [], [], [], [] ORA-00600: internal error code, arguments: [kghasp1], [0x4FA21E38], [], [], [], [], [], [] ORA-00600: internal error code, arguments: [kghasp1], [0x4FA21E38], [], [], [], [], [], [] ORA-00600: internal error code, arguments: [kghasp1], [0x4FA21E38], [], [], [], [], [], [] ORA-07445: exception encountered: core dump [smbput()+10979] [SIGSEGV] [Address NOT mapped TO object] [0x31303200] [] [] . . . Wed DEC 7 17:36:33 2011 Errors IN file /u01/oracle/admin/oric/udump/oric1_ora_30089.trc: ORA-07445: exception encountered: core dump [kghalf()+743] [SIGSEGV] [Address NOT mapped TO object] [0x1FE0] [] [] . . . Thu DEC 8 14:16:01 2011 Errors IN file /u01/oracle/admin/oric/udump/oric1_ora_9172.trc: ORA-07445: exception encountered: core dump [smbput()+10979] [SIGSEGV] [Address NOT mapped TO object] [0x34303133] [] [] Thu DEC 8 14:16:02 2011 Errors IN file /u01/oracle/admin/oric/udump/oric1_ora_9172.trc: ORA-07445: exception encountered: core dump [kghbigasp()+289] [SIGSEGV] [Address NOT mapped TO object] [0xEDC0DCC4] [] [] ORA-07445: exception encountered: core dump [smbput()+10979] [SIGSEGV] [Address NOT mapped TO object] [0x34303133] [] [] Thu DEC 8 14:16:02 2011 Errors IN file /u01/oracle/admin/oric/udump/oric1_ora_9172.trc: ORA-07445: exception encountered: core dump [kghbigasp()+289] [SIGSEGV] [Address NOT mapped TO object] [0xEDC0DCC4] [] [] ORA-07445: exception encountered: core dump [kghbigasp()+289] [SIGSEGV] [Address NOT mapped TO object] [0xEDC0DCC4] [] [] ORA-07445: exception encountered: core dump [smbput()+10979] [SIGSEGV] [Address NOT mapped TO object] [0x34303133] [] [] . . . Fri DEC 9 08:29:22 2011 Errors IN file /u01/oracle/admin/oric/udump/oric1_ora_9320.trc: ORA-07445: exception encountered: core dump [00000001] [SIGSEGV] [Address NOT mapped TO object] [0x1] [] [] . . . Fri DEC 9 14:09:34 2011 Errors IN file /u01/oracle/admin/oric/udump/oric1_ora_3437.trc: ORA-07445: exception encountered: core dump [qerhjGetNextRowPiece()+15] [SIGSEGV] [Address NOT mapped TO object] [0x4] [] [] Fri DEC 9 14:10:13 2011 Trace dumping IS performing id=[cdmp_20111209141013] Fri DEC 9 14:54:05 2011 Errors IN file /u01/oracle/admin/oric/udump/oric1_ora_3425.trc: ORA-07445: exception encountered: core dump [ksfd_gosdrq()+158] [SIGSEGV] [Address NOT mapped TO object] [0x23F9] [] [] . . . Mon DEC 12 10:06:32 2011 Errors IN file /u01/oracle/admin/oric/udump/oric1_ora_27737.trc: ORA-07445: exception encountered: core dump [qerhjGetNextRowPiece()+15] [SIGSEGV] [Address NOT mapped TO object] [0x4] [] [] . . . Tue DEC 13 09:00:45 2011 Errors IN file /u01/oracle/admin/oric/udump/oric1_ora_28549.trc: ORA-07445: exception encountered: core dump [ksmarfg()+296] [SIGSEGV] [Address NOT mapped TO object] [0xB7758000] [] [] Tue DEC 13 09:00:46 2011 Trace dumping IS performing id=[cdmp_20111213090046] Tue DEC 13 09:50:30 2011 Errors IN file /u01/oracle/admin/oric/udump/oric1_ora_28539.trc: ORA-07445: exception encountered: core dump [ksfd_gosdrq()+236] [SIGSEGV] [Address NOT mapped TO object] [0xFFCE0831] [] [] |
节点2上的错误包括：
Wed Nov 23 09:23:55 2011 Errors IN file /u01/oracle/admin/oric/udump/oric2_ora_500.trc: ORA-07445: exception encountered: core dump [smbput()+10979] [SIGSEGV] [Address NOT mapped TO object] [0xBECB0008] [] [] Wed Nov 23 09:23:55 2011 Errors IN file /u01/oracle/admin/oric/udump/oric2_ora_500.trc: ORA-07445: exception encountered: core dump [kghbigasp()+289] [SIGSEGV] [Address NOT mapped TO object] [0xE1BB2100] [] [] ORA-07445: exception encountered: core dump [smbput()+10979] [SIGSEGV] [Address NOT mapped TO object] [0xBECB0008] [] [] Wed Nov 23 09:23:55 2011 Errors IN file /u01/oracle/admin/oric/udump/oric2_ora_500.trc: ORA-07445: exception encountered: core dump [kghbigasp()+289] [SIGSEGV] [Address NOT mapped TO object] [0xE1BB2100] [] [] ORA-07445: exception encountered: core dump [kghbigasp()+289] [SIGSEGV] [Address NOT mapped TO object] [0xE1BB2100] [] [] ORA-07445: exception encountered: core dump [smbput()+10979] [SIGSEGV] [Address NOT mapped TO object] [0xBECB0008] [] [] Wed Nov 23 10:16:36 2011 Errors IN file /u01/oracle/admin/oric/udump/oric2_ora_486.trc: ORA-07445: exception encountered: core dump [kghtshrt()+76] [SIGSEGV] [Address NOT mapped TO object] [0xEE9F0305] [] [] Wed Nov 23 10:16:36 2011 Errors IN file /u01/oracle/admin/oric/udump/oric2_ora_486.trc: ORA-07445: exception encountered: core dump [kghbigasp()+289] [SIGSEGV] [Address NOT mapped TO object] [0xC7D8B9D8] [] [] ORA-07445: exception encountered: core dump [kghtshrt()+76] [SIGSEGV] [Address NOT mapped TO object] [0xEE9F0305] [] [] Wed Nov 23 10:16:37 2011 Errors IN file /u01/oracle/admin/oric/udump/oric2_ora_486.trc: ORA-07445: exception encountered: core dump [kghbigasp()+289] [SIGSEGV] [Address NOT mapped TO object] [0xC7D8B9D8] [] [] ORA-07445: exception encountered: core dump [kghbigasp()+289] [SIGSEGV] [Address NOT mapped TO object] [0xC7D8B9D8] [] [] ORA-07445: exception encountered: core dump [kghtshrt()+76] [SIGSEGV] [Address NOT mapped TO object] [0xEE9F0305] [] [] Wed Nov 23 10:16:41 2011 Errors IN file /u01/oracle/admin/oric/udump/oric2_ora_16415.trc: ORA-07445: exception encountered: core dump [kghpmalo()+76] [SIGSEGV] [Address NOT mapped TO object] [0xB86BFFD4] [] [] Wed Nov 23 10:16:41 2011 Errors IN file /u01/oracle/admin/oric/udump/oric2_ora_16415.trc: ORA-00600: internal error code, arguments: [kghasp1], [0xB77B545C], [], [], [], [], [], [] ORA-07445: exception encountered: core dump [kghpmalo()+76] [SIGSEGV] [Address NOT mapped TO object] [0xB86BFFD4] [] [] Wed Nov 23 10:16:42 2011 Errors IN file /u01/oracle/admin/oric/udump/oric2_ora_16415.trc: ORA-00600: internal error code, arguments: [kghasp1], [0xB77B545C], [], [], [], [], [], [] ORA-00600: internal error code, arguments: [kghasp1], [0xB77B545C], [], [], [], [], [], [] ORA-07445: exception encountered: core dump [kghpmalo()+76] [SIGSEGV] [Address NOT mapped TO object] [0xB86BFFD4] [] [] Wed Nov 23 10:16:42 2011 Errors IN file /u01/oracle/admin/oric/udump/oric2_ora_16415.trc: ORA-00600: internal error code, arguments: [kghasp1], [0xB77B545C], [], [], [], [], [], [] ORA-00600: internal error code, arguments: [kghasp1], [0xB77B545C], [], [], [], [], [], [] ORA-00600: internal error code, arguments: [kghasp1], [0xB77B545C], [], [], [], [], [], [] ORA-07445: exception encountered: core dump [kghpmalo()+76] [SIGSEGV] [Address NOT mapped TO object] [0xB86BFFD4] [] [] Wed Nov 23 10:16:43 2011 Errors IN file /u01/oracle/admin/oric/udump/oric2_ora_16415.trc: ORA-00600: internal error code, arguments: [kghasp1], [0xB77B545C], [], [], [], [], [], [] ORA-00600: internal error code, arguments: [kghasp1], [0xB77B545C], [], [], [], [], [], [] ORA-00600: internal error code, arguments: [kghasp1], [0xB77B545C], [], [], [], [], [], [] ORA-00600: internal error code, arguments: [kghasp1], [0xB77B545C], [], [], [], [], [], [] ORA-07445: exception encountered: core dump [kghpmalo()+76] [SIGSEGV] [Address NOT mapped TO object] [0xB86BFFD4] [] [] Wed Nov 23 10:16:43 2011 Errors IN file /u01/oracle/admin/oric/udump/oric2_ora_16415.trc: ORA-00600: internal error code, arguments: [kghasp1], [0xB77B545C], [], [], [], [], [], [] ORA-00600: internal error code, arguments: [kghasp1], [0xB77B545C], [], [], [], [], [], [] ORA-00600: internal error code, arguments: [kghasp1], [0xB77B545C], [], [], [], [], [], [] ORA-00600: internal error code, arguments: [kghasp1], [0xB77B545C], [], [], [], [], [], [] ORA-00600: internal error code, arguments: [kghasp1], [0xB77B545C], [], [], [], [], [], [] ORA-07445: exception encountered: core dump [kghpmalo()+76] [SIGSEGV] [Address NOT mapped TO object] [0xB86BFFD4] [] [] Wed Nov 23 10:16:44 2011 Errors IN file /u01/oracle/admin/oric/udump/oric2_ora_16415.trc: ORA-00600: internal error code, arguments: [kghasp1], [0xB77B545C], [], [], [], [], [], [] ORA-00600: internal error code, arguments: [kghasp1], [0xB77B545C], [], [], [], [], [], [] ORA-00600: internal error code, arguments: [kghasp1], [0xB77B545C], [], [], [], [], [], [] ORA-00600: internal error code, arguments: [kghasp1], [0xB77B545C], [], [], [], [], [], [] ORA-00600: internal error code, arguments: [kghasp1], [0xB77B545C], [], [], [], [], [], [] ORA-00600: internal error code, arguments: [kghasp1], [0xB77B545C], [], [], [], [], [], [] ORA-07445: exception encountered: core dump [kghpmalo()+76] [SIGSEGV] [Address NOT mapped TO object] [0xB86BFFD4] [] [] Wed Nov 23 10:16:45 2011 Errors IN file /u01/oracle/admin/oric/udump/oric2_ora_16415.trc: ORA-00600: internal error code, arguments: [kghasp1], [0xB77B545C], [], [], [], [], [], [] ORA-00600: internal error code, arguments: [kghasp1], [0xB77B545C], [], [], [], [], [], [] ORA-00600: internal error code, arguments: [kghasp1], [0xB77B545C], [], [], [], [], [], [] ORA-00600: internal error code, arguments: [kghasp1], [0xB77B545C], [], [], [], [], [], [] ORA-00600: internal error code, arguments: [kghasp1], [0xB77B545C], [], [], [], [], [], [] ORA-00600: internal error code, arguments: [kghasp1], [0xB77B545C], [], [], [], [], [], [] ORA-00600: internal error code, arguments: [kghasp1], [0xB77B545C], [], [], [], [], [], [] ORA-07445: exception encountered: core dump [kghpmalo()+76] [SIGSEGV] [Address NOT mapped TO object] [0xB86BFFD4] [] [] Wed Nov 23 10:16:46 2011 Errors IN file /u01/oracle/admin/oric/udump/oric2_ora_16415.trc: ORA-00600: internal error code, arguments: [kghasp1], [0xB77B545C], [], [], [], [], [], [] ORA-00600: internal error code, arguments: [kghasp1], [0xB77B545C], [], [], [], [], [], [] ORA-00600: internal error code, arguments: [kghasp1], [0xB77B545C], [], [], [], [], [], [] ORA-00600: internal error code, arguments: [kghasp1], [0xB77B545C], [], [], [], [], [], [] ORA-00600: internal error code, arguments: [kghasp1], [0xB77B545C], [], [], [], [], [], [] ORA-00600: internal error code, arguments: [kghasp1], [0xB77B545C], [], [], [], [], [], [] ORA-00600: internal error code, arguments: [kghasp1], [0xB77B545C], [], [], [], [], [], [] ORA-00600: internal error code, arguments: [kghasp1], [0xB77B545C], [], [], [], [], [], [] ORA-07445: exception encountered: core dump [kghpmalo()+76] [SIGSEGV] [Address NOT mapped TO object] [0xB86BFFD4] [] [] . . . Wed Nov 30 15:09:15 2011 Errors IN file /u01/oracle/admin/oric/udump/oric2_ora_8526.trc: ORA-07445: exception encountered: core dump [ksmarfg()+296] [SIGSEGV] [Address NOT mapped TO object] [0xB7758000] [] [] Wed Nov 30 15:09:16 2011 Trace dumping IS performing id=[cdmp_20111130150916] Wed Nov 30 15:09:27 2011 Errors IN file /u01/oracle/admin/oric/udump/oric2_ora_26073.trc: ORA-07445: exception encountered: core dump [ksmarfg()+296] [SIGSEGV] [Address NOT mapped TO object] [0xB7758000] [] [] . . . Fri DEC 9 11:01:00 2011 Errors IN file /u01/oracle/admin/oric/udump/oric2_ora_7421.trc: ORA-07445: exception encountered: core dump [kghalf()+743] [SIGSEGV] [Address NOT mapped TO object] [0x1FE0] [] [] . . . Tue DEC 13 10:24:20 2011 Errors IN file /u01/oracle/admin/oric/udump/oric2_ora_7413.trc: ORA-07445: exception encountered: core dump [kcbhfho()+50] [SIGSEGV] [Address NOT mapped TO object] [0xCDC4B5AF] [] [] Tue DEC 13 10:24:20 2011 Errors IN file /u01/oracle/admin/oric/udump/oric2_ora_7413.trc: ORA-07445: exception encountered: core dump [kghbigasp()+289] [SIGSEGV] [Address NOT mapped TO object] [0xB9455B58] [] [] ORA-07445: exception encountered: core dump [kcbhfho()+50] [SIGSEGV] [Address NOT mapped TO object] [0xCDC4B5AF] [] [] Tue DEC 13 10:24:21 2011 Errors IN file /u01/oracle/admin/oric/udump/oric2_ora_7413.trc: ORA-07445: exception encountered: core dump [kghbigasp()+289] [SIGSEGV] [Address NOT mapped TO object] [0xB9455B58] [] [] ORA-07445: exception encountered: core dump [kghbigasp()+289] [SIGSEGV] [Address NOT mapped TO object] [0xB9455B58] [] [] ORA-07445: exception encountered: core dump [kcbhfho()+50] [SIGSEGV] [Address NOT mapped TO object] [0xCDC4B5AF] [] [] Tue DEC 13 10:33:46 2011 Errors IN file /u01/oracle/admin/oric/udump/oric2_ora_7407.trc: ORA-07445: exception encountered: core dump [ksmarfg()+296] [SIGSEGV] [Address NOT mapped TO object] [0xB74D7000] [] [] Tue DEC 13 10:33:48 2011 Trace dumping IS performing id=[cdmp_20111213103348] Tue DEC 13 10:41:50 2011 Errors IN file /u01/oracle/admin/oric/udump/oric2_ora_7371.trc: ORA-07445: exception encountered: core dump [qerhjGetNextRowPiece()+15] [SIGSEGV] [Address NOT mapped TO object] [0x4] [] [] |
上面出现了多个ORA-7445错误，包括ORA-7445 [kghalf]、ORA-7445[smbput]、ORA-7445[00000001]、ORA-7445[qerhjGetNextRowPiece]、ORA-7445[ksfd_gosdrq]、ORA-7445[ksmarfg]、ORA-7445[kghtshrt]、ORA-7445[kghpmalo]和ORA-[kcbhfho]。有些ORA-7445还会伴随ORA-600错误。而且这些错误有一少半，在MOS中根本找不到对应的记录。
不过经检查发现，所有的ORA-600和ORA-7445错误都与同一个SQL语句有关：
SELECT T1.*
FROM
(
SELECT T.*,ROWNUM R
FROM
(
SELECT TAB1.*
FROM U1.TAB1 TAB1
WHERE TAB1.ID IN
(
SELECT TAB2.ID
FROM U1.TAB1 TAB1 ,U1.TAB2 TAB2
WHERE TAB1.ID=TAB2.ID
AND (ACID=’172037402731702′ OR ACRID IN (‘U172037402731702′,’D254798800365602′,’O152577300452002′,’O152577600462102’,
‘O249489802110302′,’P251776610703402′,’P249489810670402′,’P249489810680502′,’T107800000310′,’T249490300520702′,’T411499000263′))
AND ACNAME!=’1a’)
AND TAB1.PID IN (‘152566403159202′,’152610903160202′,’152622903172402′,’152703503200202′,’153158303221502’,
‘168004703241802’,’173153203272602′,’184980303328402′,’184980903332802′,’185142803340602′,’185848503350402′,
‘185851603365702’,’185851803376802′,’188153303449102′,’188153803450702′,’188154903462302′,’190177403490202′,
‘241273703509800’,’246885303517000′,’246900503523002′,’247310803539602′,’251787803620602′,’251813603659702′,
‘252391203700302’,’255115403877602′,’255370103881002′,’255373403897402′,’255376003905102′,’255834303911102′,
‘57555103980202’,’257555503992102′,’257803904023202′,’258417704030202′,’258448804040302′,’258449104051702′,
‘268091104094802’,’270679304112602′,’271251704122702′,’271800404138802′,’271815004144902′,’271816904159502′,
‘271965804164202’,’273704604172702′,’274590404190202′,’280720104192902′,’284353504233502′,’284354004247602′,
‘284354104251302’,’288819804327802′,’288829704355602′,’289099304367102′,’289786004378302′,’290681304390802′,
‘292272404437202’,’292380904440302′,’292384804458702′,’293129404463602′,’293134104487902′,’293274604507902′,
‘293993404523902’,’294289504549802′,’294693104550102′,’294718104561402′,’294718104575002′,’295007604589402′,
‘295013404607502’,’295722404611702′,’296125204620202′,’296300404648202′,’296716204652302′,’297710904667402′,
‘297856504677102’,’298902304689602′,’300050604709102′,’300051804710602′,’300777204721702′,’308108504766302′,
‘309372804770202’,’309829004782402′,’309831704795702′,’310273804811202′,’310651033655′,’310670034172′,
‘310845304823402’,’311420304851302′,’313402604910202′,’3161604972102′,’316457404983402′,’316887404991902′,
‘316892505007902’,’317174405010702′,’324060005027702′,’324490405030202′,’341348705173702′,’360825605207102′,
‘409755039057’,’477703004325′)
AND STATUS=’01’
ORDER BY TAB1.LMT DESC
) T
) T1
WHERE R>=1 AND R<21;
显然这些错误的本源和当前SQL有关系，而不同的错误信息只是不同的表相而已。根据MOS中记载的信息判断，问题应该是文档ORA-7445 KSMARFG / KGHALF Using PGA_AGGREGATE_TARGET [ID 743951.1]描述的bug。
导致这个问题的原因是9.2.0.3和9.2.0.4版在使用PGA_AGGREGATE_TARGET参数时，如果PGA的大小发生了改变，可能导致PGA内存corruption。解决的办法除了升级到9.2.0.5及以上版本外，采用手工方式设置工作区大小，以及修改问题SQL语句都是相对快速的解决问题的方法。