select d.spid, c.object_name,a.USERNAME,a.OSUSER,a.MACHINE, a.STATUS,'ALTER SYSTEM KILL SESSION '''||a.sid||','||a.SERIAL#||''';' from v$session a ,v$locked_object b,dba_objects c,v$process d where a.SID = b.SESSION_ID and b.OBJECT_ID = c.object_id and a.paddr=d.addr
from v$session a ,v$locked_object b,dba_objects c,v$process d
where a.SID = b.SESSION_ID
and b.OBJECT_ID = c.object_id
and a.paddr=d.addr