Find oracle locked objects in oracle database

 select object_name obj

 ,oracle_username||' ('||s.status||')' oruser

 ,os_user_name osuser

 ,l.process unix

 ,''''||s.sid||','||s.serial#||'''' ss

 ,r.name rs

 ,to_char(s.logon_time,'yyyy/mm/dd hh24:mi:ss') time

 from v$locked_object l

 ,dba_objects o

 ,v$session s

 ,v$transaction t

 ,v$rollname r

 where l.object_id = o.object_id

 and s.sid=l.session_id

 and s.taddr=t.addr

 and t.xidusn=r.usn

 order by ss, obj,osuser,  obj

alter system  kill session  '6,1509'