Re: enqueues

There used to be Anjo Kolk's wait event paper at http://www.evdbt.com/event.pdf. I can't find it any more. Search for Anjo Kolk and/or "Description of Oracle7 Wait Events and Enqueues" which is its title.

Yong Huang
yong321_at_yahoo.com

"Evgeniy Krasnov" <krasnov_at_servplus.ru> wrote in message news:<a4t8ej$7gk$1_at_gavrilo.mtu.ru>...
> There are 2 cols in v$lock, id1 and id2, matching p2 and p3 in
> v$session_wait respectively.
> These are resource identifiers.
> All information I found about id1 is "The first identifier (id1) of the
> enqueue or global lock takes its value from P2 or P2RAW. The meaning of the
> identifier depends on the name (P1)".
> The same about id2
> What do these ids mean?
> For example, I have a blocking lock (which is marked 1 in block column in
> v$lock).
> I know that this lock is a RX table lock.
> Is there any way I can figure out which table is affected by this lock?
Received on Tue Feb 19 2002 - 12:53:26 CST