from v$session
Code:
ROW_WAIT_OBJ#
NUMBER
Object ID for the table containing the ROWID specified
in ROW_WAIT_ROW#
ROW_WAIT_FILE# NUMBER
Identifier for the datafile containing the ROWID
specified in ROW_WAIT_ROW#. This column is valid only
if the session is currently waiting for another
transaction to commit and the value of ROW_WAIT_OBJ#
is not -1
ROW_WAIT_BLOCK# NUMBER
Identifier for the block containing the ROWID specified
in ROW_WAIT_ROW#. This column is valid only if the session
is currently waiting for another transaction to commit and
the value of ROW_WAIT_OBJ# is not -1
ROW_WAIT_ROW# NUMBER
The current ROWID being locked. This column is valid only
if the session is currently waiting for another
transaction to commit and the value of ROW_WAIT_OBJ#
is not -1
Sam
Thanx
Sam
Life is a journey, not a destination!