结合v$locked_object和v$session视图查出SERIAL# alter system kill session 'sid,SERIAL#' immediate;
select sid,sql_text from v$open_cursors;
v$session v$sqltext关联一下就可以了 ------------------------------- select s.SID,s.TERMINAL,t.COMMAND_TYPE,t.SQL_TEXT,t.PIECE from v$session s,v$sqltext t where s.SQL_ADDRESS = t.ADDRESS and s.STATUS = 'ACTIVE' order by s.SID,t.PIECE
alter system kill session 'sid,SERIAL#' immediate;
v$sqltext关联一下就可以了
-------------------------------
select s.SID,s.TERMINAL,t.COMMAND_TYPE,t.SQL_TEXT,t.PIECE
from v$session s,v$sqltext t
where s.SQL_ADDRESS = t.ADDRESS
and s.STATUS = 'ACTIVE'
order by s.SID,t.PIECE