select db.object_name,sess.sid,sess.serial#,sess.module,sess.action ,
'alter system kill session '''|| sess.sid ||','||sess.serial#||'''',sess.OSUSER from
v$locked_object obj,
dba_objects db,
v$session sess
where obj.object_id=db.object_id
and obj.session_id=sess.sid;