Re: Which user has obtained the Lock ???

Hi,
Which views should i join and what is the query to find out the user who has a row level lock on a particular row in a table using select ... for update.

Is it possible to find the user or not.

Thanks in Advance

Anurag

In article <3A0C10C9.A226FCB4_at_fmr.com>,
  Karen <karen.abgarian_at_fmr.com> wrote:
> Hi,
>
> The statement below tries to obtain both the lock for the table and
> the locks for individual rows.
>
> You can find out who is holding the lock by joining V$LOCKED_OBJECT,
> DBA_OBJECTS and if needed V$SESSION. The OBJECT_ID column
> in v$locked_object relates to the locked table, the name of the
 object can
> be
> gotten from dba_objects.
>
> Regards
> Karen.
>
> anuragmin_at_my-deja.com wrote:
>
> > Hi,
> > When I query using the command
> >
> > select * from foo where id = 100 for update nowait;
> >
> > Does this statement try to obtain a table level lock or row level
 lock.
> >
> > Also If I am unable to obtain the lock using the above statement
 how
> > do i find out which d/b user, o/s user and session has obtained the
> > lock.
> >
> > Thanks in Advance for your help
> >
> > Anurag
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Nov 13 2000 - 13:17:54 CST