变成killed就可以了执行后 SQL> select * from a; select * from a * ERROR 位于第1行: ORA-00028: 您的会话己被删去
select s.sid,s.machine,o.object_name,l.oracle_username,l.locked_mode, 'ALTER SYSTEM KILL SESSION '''||s.sid||', '||s.serial#||''';' Command from v$locked_object l,v$session s,all_objects o where l.session_id=s.sid and l.object_id=o.object_id再用 ALTER SYSTEM KILL SESSION 'sid,serial#'
1、要杀掉一个session应先应知道其sid和serial#,假设你已经知道。 2、使用ALTER SYSTEM KILL SESSION 'v_sid,v_serial#' immediate; 试一试如不行转3. 3、select paddr from v$session where sid=v_sid and serial#=v_serial# select spid from v$process where addr=paddr(以上语句所查出的); 转到操作系统下执行:kill -9 spid (以上语句所查出的)
select sid,serial,username from v$session; 然后删除该会话,会话标识符和序号为11和9; alter system kill session '11,9';
既是已经杀掉了
SQL> select * from a;
select * from a
*
ERROR 位于第1行:
ORA-00028: 您的会话己被删去
'ALTER SYSTEM KILL SESSION '''||s.sid||', '||s.serial#||''';' Command
from v$locked_object l,v$session s,all_objects o
where l.session_id=s.sid and l.object_id=o.object_id再用
ALTER SYSTEM KILL SESSION 'sid,serial#'
2、使用ALTER SYSTEM KILL SESSION 'v_sid,v_serial#' immediate; 试一试如不行转3.
3、select paddr from v$session where sid=v_sid and serial#=v_serial#
select spid from v$process where addr=paddr(以上语句所查出的);
转到操作系统下执行:kill -9 spid (以上语句所查出的)
然后删除该会话,会话标识符和序号为11和9;
alter system kill session '11,9';