今天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
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
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
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博客 ” ,链接:http://blog.itpub.net/24849178/viewspace-743209/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/24849178/viewspace-743209/