Hi All,
Below link gives good info about V$lock table. Most of us will face issue relating to locking some or other time
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