Re: ? regarding lock on rows

#1

Originally posted by Sricharan Saripalli

Quote:

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: ? regarding lock on rows

comp.databases.oracle.misc comp.databases.oracle.misc

Re: ? regarding lock on rows - 07-18-2003 , 03:24 PM