select a.object_id,a.session_id,b.object_name
from v$locked_object a,dba_objects b
where a.object_id = b.object_id;
select sid,serial# from v$session where sid = 99;
alter system kill session '33,9';
select 'alter system
kill session ''' || sid ||','|| serial# ||''''
from v$session where sid in (99)
select 'alter system kill session ''' || sid ||','|| serial# ||''''
from v$session where sid in (99)
No comments:
Post a Comment