declare
cursor cur_2
is
select object_name,machine,s.sid,s.serial# serial
from v$locked_object l,dba_objects o,v$session s
where l.object_id = o.object_id and l.session_id=s.sid
and o.owner not in 'sys,system';
cursor cur_2
is
select object_name,machine,s.sid,s.serial# serial
from v$locked_object l,dba_objects o,v$session s
where l.object_id = o.object_id and l.session_id=s.sid
and o.owner not in 'sys,system';
----这个地方可以加些限定条件，来满足自己的需求
c2 cur_2%rowtype;
ssid varchar2(100);
sser varchar2(100);
v_sql varchar2(200);
begin
open cur_2;
loop
fetch cur_2 into c2;
exit when cur_2%notfound;
ssid:=c2.sid||','||c2.serial;
v_sql:='alter system kill session '''||ssid||''' ';
execute immediate v_sql;
dbms_output.put_line(v_sql);
end loop ;
close cur_2;
end ;
/
[@more@]
c2 cur_2%rowtype;
ssid varchar2(100);
sser varchar2(100);
v_sql varchar2(200);
begin
open cur_2;
loop
fetch cur_2 into c2;
exit when cur_2%notfound;
ssid:=c2.sid||','||c2.serial;
v_sql:='alter system kill session '''||ssid||''' ';
execute immediate v_sql;
dbms_output.put_line(v_sql);
end loop ;
close cur_2;
end ;
/
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/39335/viewspace-1019511/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
龙蛇演义--国术的修炼
下一篇：
没有了~
请登录后发表评论
登录
全部评论
