RSA Scripts

Kill Session

Kill Session by using V$ tables.

  1. Oracle
  2. Connection
  3. Beginner
  4. Vaknin Sammy

Last updated:

Warning: Review and test in a non-production environment before running.

Back to results

select c.owner, c.object_name, c.object_type,b.sid, b.serial#, b.status, b.osuser, b.machine
from v$locked_object a , v$session b, dba_objects c
where b.sid = a.session_id
and a.object_id = c.object_id;


ALTER SYSTEM KILL SESSION 'sid,serial#';