Oracle SQL: How to find session that is blocking any object: For Monitoring

--List the session that is blocking any object: for Monitoring

 

select O.object_name,O.object_type,S.sid,S.UserName,S.MACHINE, S.serial#,L.oracle_username,L.os_user_name,L.locked_mode

from dba_objects O,v$locked_object L,v$session S

where O.object_id = L.object_id and S.sid = L.session_id

 

Thanks & Regards

Fauzi