Re: v$lock info

Thanks Anjo

for opening my eyes (again). Guess I was too focused on the Waits-section. It was in particular the info on CI-locks I needed, but I got greedy and asked for info on all types of locks. Your doc does indeed cover the material I asked for. Would there by any chance be an 8i version on the drawing board?

Regards,
Ivan Bajon

"Anjo Kolk" <k.kolk_at_chello.nl> wrote in message news:3AE29601.359C5F8B_at_chello.nl...
>
> Ivan,
>
> The document that I wrote should have this information in it. There is a
> chapter about enqueues and there I talk about id1 and id2 for most locks.
>
> Anjo Kolk
>
>
> Ivan Bajon wrote:
>
> > Hi all
> >
> > (any version)
> >
> > Does anyone know of a place where I can get info on how to interpret id1
 and
> > id2 from v$lock? I already know that if id2=0 you can join with obj$ to
 get
> > object name. However, I'd like the full story. How are the numbers
> > interpreted if id2 <> 0? What I'm looking for, I guess, is something
 similar
> > to Anjo Kolk's document about the wait interface. Does such a document
 exist
> > for lock interpretation?
> >
> > Regards,
> > Ivan Bajon
>
Received on Sun Apr 22 2001 - 15:14:32 CDT