About Oracle BlockSession

Oracle BlockSession处理

select username,blocking_session,blocking_session_status from v$session where blocking_session_status='VALID';
--if blocking_session=97 
select sid ,serial# from v$session where sid = 97;
--if sid=97 ,serial#=16976
alter system kill session '97,16976';