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