ORACLE locks report script

the next script works on oracle 11g , report on all DB locks.

select s.osuser "O/S-User", s.username "Ora-User",s.sid "Session-ID",s.serial# "Serial",

s.process "Process-ID", s.status "Status",l.name "Obj_Locked",l.mode_held "Lock_Mode",

t.used_ublk "Left undo block"

from v$session s,dba_dml_locks l,v$process p,v$transaction t

 where l.session_id = s.sid and p.addr = s.paddr

Yaniv Tzanany