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 || ',' || serial# || ');'  as sql_text

from v$session

where 1=1

  -- and status = 'RUNNING';

  and logon_time < sysdate - 2

)

loop

execute immediate x.sql_text;

end loop;

 

end;