Re: Where does Oracle store it's locks ?

From: Michael Agbaglo <byteshif_at_cs.tu-berlin.de>
Date: 1996/11/24
Message-ID: <01bbda52$7a53b420$e0119582_at_pitfall.speedsurfers.org>#1/1


Jonathan Lewis <ora_mail_at_jlcomp.demon.co.uk> schrieb im Beitrag <3298A554.54E0_at_jlcomp.demon.co.uk>...
> Michael Agbaglo wrote:
> >
> > How can I determine which rows are locked ?
> > Don't want to do a lock attempt on each row. Is there a system table
 where
> > I can retrieve these data from ?
>
>
> Row locks are stored as flags on the rows themselves, so the only
> way to find locked rows is the one you have identified.
>

If so, what the table V$LOCK good for - and how does oracle access this flag (in the method described above) ? Received on Sun Nov 24 1996 - 00:00:00 CET

Original text of this message