select count(1),user from v$session group by user;
select 'alter system kill session '||''''||sid||','||serial#||''''||'immediate;' from v$session
select * from v$locked_object; ----- get the sid
select sid,serial# from v$session where sid=134; ------get serial#
alter system kill session '134,2386';
No comments:
Post a Comment