Hey, it's only been 48 hours according
to the timestamps on my newsreader.
I'm planning to wait about 10 days for
responses to my suggestions about a
FAQ.
However - your comments on id1/id2
are relevant only to TM locks. It used
to be the case that the Parallel Server
manual was the best place to get
information on the various ID1/ID2
values for about 20 of the lock types.
The Server reference under v$lock
itself also used to list some of them.
In both cases you may need to dust
of some of the older manuals though.
--
Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk
Practical Oracle 8i: Building Efficient Databases
Publishers: Addison-Wesley
Reviews at: http://www.jlcomp.demon.co.uk/book_rev.html
Ivan Bajon wrote in message <9broeh$avt$1_at_news.inet.tele.dk>...
>What? No replies? I know that you all have the material out there and that
>you're keeping it from me. It's a conspiracy. That's what it is. Lemme have
>that there material or I'm gonna hijack a plane or something.
>
>
>"Ivan Bajon" <bajon_at_nospam@worldonline.dk> wrote in message
>news:9bmlsl$svc$1_at_news.inet.tele.dk...
>> 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 Sat Apr 21 2001 - 06:55:41 CDT
