DanBrother的部落格

Query sessions that are being locked:
select s.username as username,
s.program as program,
s.osuser as osuser,
s.sid as sid,
s.serial# as serial#,
s.logon_time as logon_time
from v$locked_object o, v$session s
where o.session_id = s.sid
order by s.logon_time;

Query SQL Text for locked session:
select t.sql_text as sql_text
from v$session s, v$sqltext_with_newlines t
where decode(a.sql_hash_value,0,prev_hash_value,sql_hash_value) = b.hash_value
and a.sid = '{get_from_above}'
order by piece;


Kill locked session by using:
alter system kill session 'sid ,serial# ';