LOCK DETAILS AND KILL SCRIPT

select a.sid, a.serial#

from v$session a, v$locked_object b, dba_objects c

where b.object_id = c.object_id

and a.sid = b.session_id

and OBJECT_NAME= 'DUMMY';
/

alter system kill session '2278,55879';