Re: ? regarding lock on rows

Originally posted by Sricharan Saripalli
> Hi,
>
> Is it possible to find out what rows of a table are locked by the
> current session. I can get the object_id , from v$locked_objects
> for the current user. but i am not sure how to check if a
> particular row
> is locked or not.
>
> Thanks,
> Charan.
>
> Hello Charan,
>
> When there is a session locked, you can check the view v$session for
> the database session that is locked.
> The field ROW_WAIT_FILE#, shows the identifier for the datafile
> containing the row ID specified in ROW_WAIT_ROW#.
> The field ROW_WAIT_BLOCK#, shows the Identifier for the block
> containing the row ID specified in ROW_WAIT_ROW#.
> The field ROW_WAIT_ROW#, show the row ID that is locked.
> Those values must be turned to hexadecimal.
> The string:
> BBBBBBBB.RRRR.FFFF (Block.row.File) corresponds to rowid for the
> particular row locked.
>
> Bye,
>
> Carlos

--
Posted via http://dbforums.com