ORA-07445: exception encountered: core dump [kghalp()+58] [SIGSEGV] [Address not mapped to object] [0x000000068] [] []
DUMP文件
*** SERVICE NAME:(orcl) 2012-07-12 14:18:55.016
*** SESSION ID:(258.58198) 2012-07-12 14:18:55.016
Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to object), addr: 0x68, PC: [0x3c175e2, kghalp()+58]
*** 2012-07-12 14:18:55.030
ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [kghalp()+58] [SIGSEGV] [Address not mapped to object] [0x000000068] [] []
Current SQL statement for this session:
INSERT INTO MAILSENDER.GARBAGEDISTRIBUTING SELECT :B6 ,DOMAIN,MAX(CASE WHEN FLODER='ad' THEN COUNTNUM ELSE 0 END ) AS AD, MAX(CASE W
HEN FLODER='Garbage' THEN COUNTNUM ELSE 0 END) AS GARBAGE,:B3 ,:B5 ,:B4 FROM ( SELECT DOMAIN, FLODER, COUNT(MESSAGEINFOID) AS COUNTN
UM FROM( SELECT MBL.DOMAIN,T.MESSAGEINFOID,CASE WHEN REGEXP_SUBSTR(T.FLODER,'(Junk)|(QQ閭欢璁㈤槄)|(鍨冨溇閭欢)|(璁㈤槄閭欢)') IS NOT NULL
THEN 'Garbage' WHEN REGEXP_SUBSTR(T.FLODER,'(骞垮憡閭欢)') IS NOT NULL THEN 'ad' ELSE '' END AS FLODER FROM MESSAGEINFO T,MAILBOXLIST
MBL,TABLE(SPLITSTR(:B1 ,',')) TBEMAIL WHERE MBL.MAILBOXID=T.MAILBOXID AND TBEMAIL.COLUMN_VALUE=MBL.EMAIL AND T.ADDDATE BETWEEN :B3
AND :B2 AND (SELECT COUNT(*) FROM MESSAGEINFO M WHERE T.MAILID=M.MAILID AND T.MESSAGEINFOID