oracle数据库死锁解决代码

【核心代码】

SELECT s.username,l.OBJECT_ID,l.SESSION_ID,s.SERIAL#,
l.ORACLE_USERNAME,l.OS_USER_NAME,l.PROCESS 
FROM V$LOCKED_OBJECT l,V$SESSION S WHERE l.SESSION_ID=S.SID;

alter system kill session '127,41279'; 




select a.*  from(
select a.ennmcd,a.rtlv,a.dhglv,a.INMSGTM,b.RVNM,c.ennm,c.wrz,e.prf,d.wddr,d.wdsp from U_ST_RLWT a
left join U_PFST_BSINFO b on (a.ENNMCD = b.ENNMCD)
left join U_PFST_HDRFLMS  c on (b.ENNMCD = c.ENNMCD)
left join  U_ST_STWDST d on (c.ENNMCD = d.ENNMCD)
left join  U_ST_STRNST e on (d.ENNMCD = e.ENNMCD) ）a ,
(select t.ENNMCD,max(t.tm)tm from U_ST_STRNST t  group by t.ENNMCD) b 
 where a.ENNMCD=b.ENNMCD and a.INMSGTM = b.tm



select a.*  from(
select a.ennmcd,a.rtlv,a.dhglv,a.INMSGTM,b.RVNM,c.ennm,c.wrz,d.prf,e.wddr,e.wdsp from U_ST_RLWT a
left join U_PFST_BSINFO b on (a.ENNMCD = b.ENNMCD)
left join U_PFST_HDRFLMS  c on (b.ENNMCD = c.ENNMCD)
left join   U_ST_STRNST d on (c.ENNMCD = d.ENNMCD)
left join   U_ST_STWDST e on (a.ENNMCD = e.ENNMCD) )a ,
(select t.ENNMCD,max(t.tm)tm from U_ST_STRNST t  group by t.ENNMCD) b 
 where a.ENNMCD=b.ENNMCD and a.INMSGTM = b.tm
 
 select a.*  from(
select a.ennmcd,c.rtlv,c.dhglv,c.INMSGTM,a.RVNM,b.ennm,b.wrz,d.INMSGPRF,e.wddr,e.wdsp from U_PFST_BSINFO a
left join U_PFST_HDRFLMS b on (a.ENNMCD = b.ENNMCD)
left join U_ST_RLWT  c on (b.ENNMCD = c.ENNMCD)
left join   U_ST_RLRN d on (c.ENNMCD = d.ENNMCD)
left join   U_ST_STWDST e on (d.ENNMCD = e.ENNMCD) )a ,
(select t.ENNMCD,max(t.tm)tm from U_ST_STRNST t  group by t.ENNMCD) b 
 where a.ENNMCD=b.ENNMCD and a.INMSGTM = b.tm



select cast(a.stcdt as varchar(12)),a.ymdhm,a.zu,a.zd,b.ennm,b.wrz,c.ln,c.lt,c.stad from(
select * from (
 select  stcdt,ymdhm,zu,zd from gzguest.U_ST_DAM_R  where ymdhm in (select max(ymdhm) from gzguest.U_ST_DAM_R 
  group by stcdt having count(*)>1)) a)  a 
  left join gzguest.U_PFST_HDRFLMS b on (a.stcdt = b.ENNMCD )
  left join gzguest.u_pfst_bsinfo c on (b.ENNMCD = c.ENNMCD )
  where a.stcdt = b.ENNMCD  and b.ENNMCD = c.ENNMCD   and                                   
  a.ymdhm < sysdate and a.ymdhm >= sysdate - 1  
  order by c.stad,a.ymdhm desc


select ennmcd,max(tm)as tm,sum(prf)as prf from (
select ennmcd,tm,sum(prf)as prf from(
select t.ennmcd as ennmcd,substr(to_char(t.tm,'yyyy/mm/dd hh24:mi:ss'),1,13)as tm,sum(t.prf)as prf 
from gzguest.U_ST_STRNST t where  tm >= sysdate -24/24 and tm <= sysdate  group by  t.ennmcd ,tm) where ennmcd='C440184111' 
group by ennmcd,tm  order by tm desc 
) group by ennmcd


select ennmcd,tm, prf from gzguest.U_ST_STRNST  where  tm >=
                       to_date('2015-07-01 00:00:00', 'yyyy-mm-dd hh24:mi:ss')
                   and tm <
                       to_date('2015-09-02 00:00:00', 'yyyy-mm-dd hh24:mi:ss')
 and ennmcd = 'C440100011'  order by prf desc