Friday, 9 May 2014

V$lock Table in Oracle

Hi All,

Below link gives good info about V$lock table. Most of us will face issue relating to locking some or other time 





If a session holds a lock that's blocking another session, BLOCK=1

How to get the rowid of the row that is blocked

select row_wait_obj#, row_wait_file#, row_wait_block#, row_wait_row#
  2* from v$session where sid=479



select do.object_name,
  row_wait_obj#, row_wait_file#, row_wait_block#, row_wait_row#,
  dbms_rowid.rowid_create ( 1, ROW_WAIT_OBJ#, ROW_WAIT_FILE#, ROW_WAIT_BLOCK#, ROW_WAIT_ROW# )
   from v$session s, dba_objects do
   where sid in ( select  sid FROM v$SESSION
WHERE SQL_ID = '0t15js2r1s67u' )
and s.ROW_WAIT_OBJ# = do.OBJECT_ID


select * from tstlock where rowid='AAAVnHAAQAAAp0tAAA'

No comments:

Post a Comment