Re: ? regarding lock on rows

Ed Prochak <edprochak_at_adelphia.net> wrote in message news:<3E68FD4B.60308_at_adelphia.net>...
> sricharan saripalli wrote:
> >
> > 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.
>
> Why do you care?
>
> Ask your DBA. If your reason is valid, they will help.
>
> Ed Prochak
>

Charan, Oracle does not keep a list of locked rows anywhere in memory; it does not need to as it records lock information in the object data blocks when it changes them. The only way to find out if a specific row is locked is to try to retrieve it for update.

HTH -- Mark D Powell -- Received on Sun Mar 09 2003 - 12:54:45 CST