Tuesday, September 30, 2014

Kill a database session for a particular object

selectc.owner,c.object_name,c.object_type,b.sid,b.serial#,b.status,b.osuser,b.machine
fromv$locked_object a ,v$session b,dba_objects c
whereb.sid = a.session_id
anda.object_id = c.object_id;
ALTER SYSTEM KILL SESSION ',';