Search This Blog

Friday, 19 April 2013

Script to Kill Database Session in oracle



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