[oracle] table lock 확인

select 'alter system kill session '''||sid||','||serial#||''';'
from v$session
where sid in (select distinct sid from v$lock where type ='TM');