ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 同一个SQL引发多个ORA-7445错误

同一个SQL引发多个ORA-7445错误

原创 Linux操作系统 作者:yangtingkun 时间:2011-12-14 23:53:22 0 删除 编辑

在客户的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-600ORA-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.39.2.0.4版在使用PGA_AGGREGATE_TARGET参数时,如果PGA的大小发生了改变,可能导致PGA内存corruption。解决的办法除了升级到9.2.0.5及以上版本外,采用手工方式设置工作区大小,以及修改问题SQL语句都是相对快速的解决问题的方法。

 

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/4227/viewspace-713393/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
暂无介绍

注册时间:2007-12-29

  • 博文量
    1955
  • 访问量
    10385342