ORA-07445: exception encountered: core dump [kkoipt()+3881] [SIGSEGV] [Address not mapped to object] [0x000000028] [] []
Tue Feb 15 14:55:46 CST 2011
Errors in file /data/oracle/admin/mamiai/udump/mamiai_ora_18513.trc:
ORA-07445: exception encountered: core dump [kkoipt()+3881] [SIGSEGV] [Address not mapped to object] [0x000000028] [] []
Tue Feb 15 14:55:48 CST 2011
Errors in file /data/oracle/admin/mamiai/udump/mamiai_ora_18503.trc:
ORA-07445: exception encountered: core dump [kkoipt()+3881] [SIGSEGV] [Address not mapped to object] [0x000000028] [] []
Tue Feb 15 14:55:56 CST 2011
Errors in file /data/oracle/admin/mamiai/udump/mamiai_ora_18559.trc:
ORA-07445: exception encountered: core dump [kkoipt()+3881] [SIGSEGV] [Address not mapped to object] [0x000000028] [] []
cat /data/oracle/admin/mamiai/udump/mamiai_ora_18559.trc
ORA-07445: exception encountered: core dump [kkoipt()+3881] [SIGSEGV] [Address not mapped to object] [0x000000028] [] []
Current SQL statement for this session:
SELECT *
FROM (SELECT ROWNUM PAGE_RN, PAGE_A.*
FROM (SELECT MB.BULLETIN_AUTOID,
MC.VALUE,
MB.BULLETIN_TIMESTAMP,
MB.BULLETIN_SUBJECT,
MB.BULLETIN_URL,
MB.BULLETIN_URL_ENABLED,
SUM(1) OVER() TOTALCOUNT
FROM MMA_BULLETIN MB,
(SELECT SUBCLASS, VALUE
FROM MMA_COMMON
WHERE MAINCLASS = 'MENU') MC
WHERE MB.BULLETIN_ENABLED = 1
AND MC.SUBCLASS(+) = MB.BULLETIN_CLASS
ORDER BY MB.BULLETIN_AUTOID DESC) PAGE_A
WHERE ROWNUM <= 7) PAGE_B
WHERE pAGE_B.PAGE_RN > 0
最后发现竞是table 创建了过多 index