select b.owner ,
b.object_name ,
a.session_id ,
a.locked_mode ,
c.serial# ,
c.sid || ',' || c.serial# ,
c.machine ,
c.PROGRAM,
c.MODULE,
c.ACTION
from v$locked_object a,
dba_objects b ,
v$session c
where b.object_id = a.object_id
And a.session_id = c.sid
alter system kill session '396,532' immediate;
b.object_name ,
a.session_id ,
a.locked_mode ,
c.serial# ,
c.sid || ',' || c.serial# ,
c.machine ,
c.PROGRAM,
c.MODULE,
c.ACTION
from v$locked_object a,
dba_objects b ,
v$session c
where b.object_id = a.object_id
And a.session_id = c.sid
alter system kill session '396,532' immediate;