How to Check the Locked Object details

Lock related queries :

SELECT XIDUSN,OBJECT_ID,SESSION_ID,ORACLE_USERNAME,OS_USER_NAME,PROCESS from gv$locked_object;

SELECT d.OBJECT_ID, substr(OBJECT_NAME,1,20), l.SESSION_ID, l.ORACLE_USERNAME, l.LOCKED_MODE

from   v$locked_object l, dba_objects d

where  d.OBJECT_ID=l.OBJECT_ID;

SELECT ADDR, KADDR, SID, TYPE, ID1, ID2, LMODE, BLOCK from gv$lock;

SELECT a.sid, a.saddr, b.ses_addr, a.username, b.xidusn, b.used_urec, b.used_ublk

FROM   v$session a, gv$transaction b

WHERE  a.saddr = b.ses_addr;

SELECT s.sid, l.lmode, l.block, substr(s.username, 1, 10), substr(s.schemaname, 1, 10), 

       substr(s.osuser, 1, 10), substr(s.program, 1, 30), s.command

FROM   v$session s, v$lock l

WHERE  s.sid=l.sid;

SELECT  p.spid, s.sid, p.addr,s.paddr,substr(s.username, 1, 10), substr(s.schemaname, 1, 10), 

        s.command,substr(s.osuser, 1, 10), substr(s.machine, 1, 10) 

FROM    v$session s, v$process p

WHERE   s.paddr=p.addr

SELECT sid, serial#, command,substr(username, 1, 10), osuser, sql_address,LOCKWAIT, 

       to_char(logon_time, 'DD-MM-YYYY;HH24:MI'), substr(program, 1, 30)

FROM   v$session;

SELECT sid, serial#,  username, LOCKWAIT from v$session;

SELECT v.SID, v.BLOCK_GETS, v.BLOCK_CHANGES, w.USERNAME, w.OSUSER, w.TERMINAL

FROM   v$sess_io v, V$session w

WHERE  v.SID=w.SID ORDER BY v.SID;

SELECT * from dba_waiters;

SELECT waiting_session, holding_session, lock_type, mode_held

FROM   dba_waiters;

SELECT 

  p.spid                      unix_spid,

  s.sid                       sid, 

  p.addr,

  s.paddr,

  substr(s.username, 1, 10)   username, 

  substr(s.schemaname, 1, 10) schemaname, 

  s.command                   command,

  substr(s.osuser, 1, 10)     osuser, 

  substr(s.machine, 1, 25)    machine

FROM   v$session s, v$process p

WHERE  s.paddr=p.addr

ORDER BY p.spid;

ref -http://www.dbatodba.com/oracle/how-to-check-the-locked-object-details/