ORA-07445: 出现异常错误: 核心转储 [kkostran()+5665] [SIGSEGV] [Address not mapped to object] [0x000000000] [] []
Current SQL statement for this session:
SELECT
DISTINCT x.f_id,f_lotteryid,
(case when x.f_lotteryid=1 and x.f_wtype in(43,44,123) then 10000 else x.f_lotteryid end ) as f_lotid,
x.f_wtype,x.f_expect, x.f_projectid,x.f_username,
x.f_getnum,x.f_paymoney, x.f_addtime,x.f_getmoney,x.f_source,
(CASE
WHEN z.f_istraceexecpte = 1 THEN 4
WHEN z.f_iscooperatebuy = 1 AND z.f_username = x.f_username THEN 1
WHEN z.f_iscooperatebuy = 1 AND z.f_username != x.f_username THEN 2
WHEN z.f_iscooperatebuy = 0 THEN 3
END) AS f_buytype,
e.f_endtime,
sysdate,udf_weekofyear(e.f_endtime,'YYYYIW') YearWeek,
udf_weekofyear(e.f_endtime,'YYYYMM') YearMonth
,l.f_lotname,l.f_PLAYname
FROM t_gather_prouser x
INNER JOIN t_gather_project z ON x.f_lotteryid = z.f_lotteryid and x.f_projectid = z.f_id
INNER JOIN t_gather_expect e ON x.f_lotteryid = e.f_lotteryid AND x.f_expect = e.f_expect
inner join v_base_lot_play_name L ON x.f_lotteryid = l.F_LOTID and x.f_wtype = l.F_PLAYID
WHERE E.F_endTime IS NOT NULL
AND z.f_isticketout > 0 AND z.f_isreturn = 0 AND z.f_userisreturn = 0
and x.f_userisreturn= 0 and x.f_isreturn = 0
AND e.F_endTime < to_date('20100101','YYYYMMDD')
AND e.F_endTime >= to_date('20090101','YYYYMMDD')
and x.f_username ='liandtao'
Current SQL statement for this session:
SELECT
DISTINCT x.f_id,f_lotteryid,
(case when x.f_lotteryid=1 and x.f_wtype in(43,44,123) then 10000 else x.f_lotteryid end ) as f_lotid,
x.f_wtype,x.f_expect, x.f_projectid,x.f_username,
x.f_getnum,x.f_paymoney, x.f_addtime,x.f_getmoney,x.f_source,
(CASE
WHEN z.f_istraceexecpte = 1 THEN 4
WHEN z.f_iscooperatebuy = 1 AND z.f_username = x.f_username THEN 1
WHEN z.f_iscooperatebuy = 1 AND z.f_username != x.f_username THEN 2
WHEN z.f_iscooperatebuy = 0 THEN 3
END) AS f_buytype,
e.f_endtime,
sysdate,udf_weekofyear(e.f_endtime,'YYYYIW') YearWeek,
udf_weekofyear(e.f_endtime,'YYYYMM') YearMonth
,l.f_lotname,l.f_PLAYname
FROM t_gather_prouser x
INNER JOIN t_gather_project z ON x.f_lotteryid = z.f_lotteryid and x.f_projectid = z.f_id
INNER JOIN t_gather_expect e ON x.f_lotteryid = e.f_lotteryid AND x.f_expect = e.f_expect
inner join v_base_lot_play_name L ON x.f_lotteryid = l.F_LOTID and x.f_wtype = l.F_PLAYID
WHERE E.F_endTime IS NOT NULL
AND z.f_isticketout > 0 AND z.f_isreturn = 0 AND z.f_userisreturn = 0
and x.f_userisreturn= 0 and x.f_isreturn = 0
AND e.F_endTime < to_date('20100101','YYYYMMDD')
AND e.F_endTime >= to_date('20090101','YYYYMMDD')
and x.f_username ='liandtao'
SELECT
DISTINCT x.f_id,f_lotteryid,
(case when x.f_lotteryid=1 and x.f_wtype in(43,44,123) then 10000 else x.f_lotteryid end ) as f_lotid,
x.f_wtype,x.f_expect, x.f_projectid,x.f_username,
x.f_getnum,x.f_paymoney, x.f_addtime,x.f_getmoney,x.f_source,
(
CASE
WHEN z.f_istraceexecpte = 1 THEN 4
WHEN z.f_iscooperatebuy = 1 AND z.f_username = x.f_username THEN 1
WHEN z.f_iscooperatebuy = 1 AND z.f_username != x.f_username THEN 2
WHEN z.f_iscooperatebuy = 0 THEN 3
END) AS f_buytype,
e.f_endtime,
sysdate,udf_weekofyear(e.f_endtime,'YYYYIW') YearWeek,
udf_weekofyear(e.f_endtime,'YYYYMM') YearMonth
,l.f_lotname,l.f_PLAYname
FROM t_gather_prouser x
INNER JOIN t_gather_project z ON x.f_lotteryid = z.f_lotteryid and x.f_projectid = z.f_id
INNER JOIN t_gather_expect e ON x.f_lotteryid = e.f_lotteryid AND x.f_expect = e.f_expect
inner join v_base_lot_play_name L ON x.f_lotteryid = l.F_LOTID and x.f_wtype = l.F_PLAYID
WHERE E.F_endTime IS NOT NULL
AND z.f_isticketout > 0 AND z.f_isreturn = 0 AND z.f_userisreturn = 0
and x.f_userisreturn= 0 and x.f_isreturn = 0
AND e.F_endTime < to_date('20100101','YYYYMMDD')
AND e.F_endTime >= to_date('20090101','YYYYMMDD')
and x.f_username ='liandtao'
// *Cause: An OS exception occurred which should result in the creation of a
// core file. This is an internal error.
// *Action: Contact your customer support representative.metalink帐号过期了，没法查，哎
PROCESS STATE
-------------
Process global information:
process: 0x2d310d710, call: 0x2cb6b9900, xact: (nil), curses: 0x2d311e3c8, usrses: 0x2d311e3c8
----------------------------------------
SO: 0x2d310d710, type: 2, owner: (nil), flag: INIT/-/-/0x00
(process) Oracle pid=51, calls cur/top: 0x2cb6b9900/0x2d09412e8, flag: (0) -
int error: 0, call error: 0, sess error: 0, txn error 0
(post info) last post received: 0 0 0
last post received-location: No post
last process to post me: none
last post sent: 0 0 0
last post sent-location: No post
last process posted by me: none
(latch info) wait_event=0 bits=0
Process Group: DEFAULT, pseudo proc: 0x2d61405b8
O/S info: user: oracle, term: UNKNOWN, ospid: 9133
OSD pid info: Unix process pid: 9133, image: oracleBA@backup
ORACLE 10G 10204 FOR LINUX
inner join v_base_lot_play_name L
不能视图 改成表就行 怪啊