互联网服务oracle 11g

ORA-07445: 出现异常错误: 核心转储？

========= Dump for incident 216429 (ORA 7445 [kkqljpmpr()+30]) ========
----- Beginning of Customized Incident Dump(s) -----
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x78] [PC:0x1CB9312, kkqljpmpr()+30] [flags: 0x0, count: 1]
Registers:
%rax: 0x00002ad748c97a50 %rbx: 0x00002ad748c97a50 %rcx: 0x0000000abeeeb698
%rdx: 0x0000000000000000 %rdi: 0x00002ad748c97a50 %rsi: 0x0000000000000000
%rsp: 0x00007fffb1c74e60 %rbp: 0x00007fffb1c74e80 %r8: 0x00002ad748cb9638
%r9: 0x0000000000000023 %r10: 0x0000000000000001 %r11: 0x0000000000000000
%r12: 0x00002ad748eb06d8 %r13: 0x0000000000000001 %r14: 0x0000000000000000
%r15: 0x00002ad748c97a50 %rip: 0x0000000001cb9312 %efl: 0x0000000000010206

(0x1cb9312) mov 0x78(%r14),%rbx
(0x1cb9316) test %r15,%r15
(0x1cb9319) jz 0x1cb94df
(0x1cb931f) test %r14,%r14
(0x1cb9322) jz 0x1cb94df

* 2018-04-24 15:37:32.012
dbkedDefDump(): Starting a non-incident diagnostic dump (flags=0x3, level=3, mask=0x0)
----- Current SQL Statement for this session (sql_id=1xfyt3qj4hhaj) -----
with t1 as(select 接线员,前台类型,1 nums,(select case when count(1)=0 then 0 else 1 end from c_caseback where CASEID = 案件记录号) 反前台 from 后台案件表 where 主协标志=1 and 前台类型 is not null and 录入时间 BETWEEN TO_DATE('2018-04-24 00:00:00', 'YYYY-MM-DD HH24:MI:SS') AND TO_DATE('2018-04-25 00:00:00', 'YYYY-MM-DD HH24:MI:SS')),
t2 as (select a.chvid,a.chvname, a.CHVCODE,a.BGROUP,rownum rn from tabbaseperson a left join tabbasegroup b on a.deptid=b.chvid where a.ROLETYPE = 27 and a.STATE = 1 and b.pid=1505 and a.chvid=10569 and rownum <=( 111 )),
t3 as (select DURATION,AGENT_ID,PREVIOUS_STATE from jtapi_agent_state_change_log f where f.PREVIOUS_STATE_DT BETWEEN TO_DATE('2018-04-24 00:00:00', 'YYYY-MM-DD HH24:MI:SS') AND TO_DATE('2018-04-25 00:00:00', 'YYYY-MM-DD HH24:MI:SS') ),
t4 as (select count(1) nums,STATION_LOGGON_AGENT from jtapi_inbound_call f where f.station_alerting_dt BETWEEN TO_DATE('2018-04-24 00:00:00', 'YYYY-MM-DD HH24:MI:SS') AND TO_DATE('2018-04-25 00:00:00', 'YYYY-MM-DD HH24:MI:SS') group by f.STATION_LOGGON_AGENT ),
t6 as (select casetype,a.stype,caseid,type from u_jxybzzaudit a left join 后台案件表 b on a.caseid = b.案件记录号 where 录入时间 BETWEEN TO_DATE('2018-04-24 00:00:00', 'YYYY-MM-DD HH24:MI:SS') AND TO_DATE('2018-04-25 00:00:00', 'YYYY-MM-DD HH24:MI:SS') ),
t9 as (select count(distinct a.案件记录号) nums, 接线员 from 案件申请表 a left join 后台案件表 b on a.案件记录号= b.案件记录号 where a.退件原因归责=1 group by 接线员)
select a.CHVCODE,a.chvname as 姓名, a.chvid,
nvl((select sum(nums) from t4 where t4.STATION_LOGGON_AGENT = a.CHVCODE ),0) 接听总数,
nvl((select TRUNC(sum(DURATION)/60,2) from t3 where t3.AGENT_ID = a.CHVCODE),0) 通话总时长,
nvl((select count(1) from t1 where t1.接线员 = a.chvid and 前台类型 in (1,2,3,4)),0) 有效电话,
to_char(decode((nvl((select sum(nums) from t1),0) - nvl((select sum(nums) from t9),0)),0,0,
round(
(((nvl((select sum(nums) from t1 where t1.接线员=a.chvid),0) - nvl((select sum(nums) from t9 where t9.接线员=a.chvid),0))/(

   ((nvl((select sum(nums) from t1),0) - nvl((select sum(nums) from t9),0)))/(select count(1) from t2)))-1),4))*100,'FM99990.099')||'%'  有效记单增量,

'100%' as 接通率,'100%' as 接听满意率,
(select (1-TRUNC(case when count(distinct caseid) =0 then 1 else (count(case when type=0 then 1 end)/count(distinct caseid)) end,4)) from t6 where casetype=0 and stype=4) || '%' 在线办结准确率,
(select (1-TRUNC(case when count(distinct caseid) =0 then 1 else (count(case when type=0 then 1 end)/count(distinct caseid)) end,4)) from t6 where casetype=0 and stype=3) || '%' 在线转办准确率,
(select (1-TRUNC(case when count(nums) =0 then 1 else (count(case when 反前台=1 then 1 end)/count(nums)) end,4)) from t1 where 前台类型=2) || '%' 发送后台准确率,
nvl((select sum(nums) from t1 where t1.接线员 = a.chvid and 前台类型 =5),0) 无效电话,
nvl((select TRUNC(sum(DURATION)/60,2) from t3 where t3.AGENT_ID = a.CHVCODE ),0) 在线时长,
nvl((select TRUNC(sum(DURATION)/60,2) from t3 where PREVIOUS_STATE='WORK_NOT_READY' and t3.AGENT_ID = a.CHVCODE ),0) 置闲时长,
nvl((select TRUNC(sum(DURATION)/60,2) from t3 where PREVIOUS_STATE='READY' and t3.AGENT_ID = a.CHVCODE ),0) 置忙时长,
nvl((select sum(nums) from t1 where t1.接线员 = a.chvid and t1.前台类型 =2),0) 发送后台数,
nvl((select sum(nums) from t1 where t1.接线员 = a.chvid and t1.前台类型 =4),0) 在线办结数,
nvl((select sum(nums) from t1 where t1.接线员 = a.chvid and t1.前台类型 =3),0) 在线转办数,
nvl((select TRUNC(sum(DURATION)/60,2) from t3 where PREVIOUS_STATE='BUSY' and t3.AGENT_ID = a.CHVCODE ),0) 通话总时长,
nvl((select TRUNC((sum(DURATION)/count(1))/60,2) from t3 where PREVIOUS_STATE='BUSY' and t3.AGENT_ID = a.CHVCODE ),0) 通话平均时长,
nvl((select count(1) from t1 where 反前台=1 and t1.接线员 = a.chvid),0) 退回数,
0 晚班数,