Transaction Lock 및 오래된 SESSION 삭제

select 'alter system kill session (' || sid || ',' || serial# || ');' from v$session where 1=1 and sid in ('616','773','788','793','801','818') --and status = 'RUNNING'; ; select * from v$transaction ---------------------------------------------------------------------- -- 오래동안 실행중인 SESSION 지우기 declare v_sql varchar2(2000); begin for X in ( select distinct 'alter system kill session (' || sid ||..

원문링크 : Transaction Lock 및 오래된 SESSION 삭제