oracle删除所有被锁死的,ORACLE删除锁死教程-Oracle

delete from TMP_MZRBB_CZYXMTJ1;

insert into TMP_MZRBB_CZYXMTJ1(sfxmflmc,sfbz,je,wssdm,pxxh,xmfl)

Select b.sfxmflmc

,a.sfbz

,sum(b.je) as je

,b.wssdm

,0 as pxxh

,(select dmz from sys1_code d where d.fldm=’1920′ and d.xmdm=c.xmlbdm) as xmfl

From mz_sfzb a,mz_sfmx b,UV_BASE_XMXXK C

Where a.id=b.zb_id

— and a.czrybm=PARM_CZYDM

and a.wssdm=b.wssdm

and a.wssdm=c.wssdm

and b.itemclass =c.xmlbdm

and b.itemcode=c.ypdm

–and isnull(a.cfysid,”) <> ”

Group by b.sfxmflmc,b.wssdm,a.sfbz,c.xmlbdm;

ALTER system kill session ‘286, 2184’