Re: Why do I see multiple ST locks?

Isn't that obvious? I missed that. Thanks, Mark.

Yong Huang
yong321_at_yahoo.com

mark.powell_at_eds.com (Mark D Powell) wrote in message news:<178d2795.0106162106.7a23af47_at_posting.google.com>...
> yong321_at_yahoo.com (Yong Huang) wrote in message
> > ADDR KADDR SID TY ID1 ID2 LMODE REQUEST CTIME BLOCK
> >
> > 791D1BAC 791D1BBC 15 ST 0 0 6 0 14 1
> > 791D1A08 791D1A18 27 ST 0 0 0 6 9 0
> > 791D18A0 791D18B0 68 ST 0 0 0 6 12 0
> > 791D1990 791D19A0 76 ST 0 0 0 6 9 0
> > 791D1A44 791D1A54 159 ST 0 0 0 6 12 0
> >
> > I thought there should only be one ST enqueue in the entire database.
> > So what's wrong?
> >
> > Yong Huang
> > yong321_at_yahoo.com
>
> Yong, only one session has the ST lock (per Lmode exclusive), everyone
> else is waiting for the single existing ST lock (per lmode =0 ,
> request non-zero).
>
> -- Mark D Powell --
Received on Mon Jun 18 2001 - 00:56:46 CDT