今天log中出现ORA-07445: exception encountered: core dump [00000001007B3808] [SIGSEGV] [Address not mapped to object] [0x000000000] [] []

查看trace文件：

*** SESSION ID:(117.2704) 2012-09-12 09:59:12.146
Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to object), addr: 0x
0, PC: [0x1007b3808, 00000001007B3808]
*** 2012-09-12 09:59:12.160

ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [00000001007B3808] [SIGSEGV] [Address not mapped to object] [0x000000000] [] []
Current SQL statement for this session:
SELECT * FROM
       (select ROWID, AREA_ID,CREATOR,TEMPERATURE,HUMIDITY,CREATION_DATE,
          TEMPERATURE-LAG(TEMPERATURE,1,0) over (partition by AREA_ID order by C
REATION_DATE desc) E1,
          TEMPERATURE-LAG(TEMPERATURE,2,0) over (partition by AREA_ID order by C
REATION_DATE desc) E2,
          TEMPERATURE-LAG(TEMPERATURE,3,0) over (partition by AREA_ID order by C
REATION_DATE desc) E3,
          TEMPERATURE-LAG(TEMPERATURE,4,0) over (partition by AREA_ID order by C
REATION_DATE desc) E4,
          TEMPERATURE-LAG(TEMPERATURE,5,0) over (partition by AREA_ID order by C
REATION_DATE desc) E5
             from mgssfcs.MDS_TEMPERATURE_LOG where CREATION_DATE>sysdate-1/12)
WHERE E1=0 AND E2=0 AND E3 = 0 AND E4=0 AND E5 = 0

执行该sql 出现ERROR at line 1:
ORA-03113: end-of-file on communication channel

解决方法：去除rowid

由于rowid在应用中没有作用，将rowid去除该sql正常执行

SELECT * FROM
       (select AREA_ID,CREATOR,TEMPERATURE,HUMIDITY,CREATION_DATE,
          TEMPERATURE-LAG(TEMPERATURE,1,0) over (partition by AREA_ID order by C
REATION_DATE desc) E1,
          TEMPERATURE-LAG(TEMPERATURE,2,0) over (partition by AREA_ID order by C
REATION_DATE desc) E2,
          TEMPERATURE-LAG(TEMPERATURE,3,0) over (partition by AREA_ID order by C
REATION_DATE desc) E3,
          TEMPERATURE-LAG(TEMPERATURE,4,0) over (partition by AREA_ID order by C
REATION_DATE desc) E4,
          TEMPERATURE-LAG(TEMPERATURE,5,0) over (partition by AREA_ID order by C
REATION_DATE desc) E5
             from mgssfcs.MDS_TEMPERATURE_LOG where CREATION_DATE>sysdate-1/12)
WHERE E1=0 AND E2=0 AND E3 = 0 AND E4=0 AND E5 = 0

但是我执行下面sql又没问题，所以还没能找到好的解决方法

       select ROWID, AREA_ID,CREATOR,TEMPERATURE,HUMIDITY,CREATION_DATE,
          TEMPERATURE-LAG(TEMPERATURE,1,0) over (partition by AREA_ID order by C
REATION_DATE desc) E1,
          TEMPERATURE-LAG(TEMPERATURE,2,0) over (partition by AREA_ID order by C
REATION_DATE desc) E2,
          TEMPERATURE-LAG(TEMPERATURE,3,0) over (partition by AREA_ID order by C
REATION_DATE desc) E3,
          TEMPERATURE-LAG(TEMPERATURE,4,0) over (partition by AREA_ID order by C
REATION_DATE desc) E4,
          TEMPERATURE-LAG(TEMPERATURE,5,0) over (partition by AREA_ID order by C
REATION_DATE desc) E5
             from mgssfcs.MDS_TEMPERATURE_LOG where CREATION_DATE>sysdate-1/12

ITPub博客

ORA-07445 [SIGSEGV] [Address not mapped to object]

最新文章