Please disregard the typo. Latch# was 34 and not 32.
maks wrote:
> Mark D Powell wrote:
> > maks, what query did you use and where is the output of that query?
> > Log Writer can take several latches depending on exactly where in
its
> > processing it happens to be:
> >
> > Also what version of Oracle? After all versions 9.2 and 10g have
> > sharable latches.
> >
> > HTH -- Mark D Powell --
>
> I used query against v$session_wait and then v$latchname to get the
> latch name. DB version was 9.2.0.6 on AIX 5.1.
>
> Sess W'd So Time
> ID Wait Event Wait State Far (ms) W'd (ms)
> P1TXT P1 P2TXT P2 P3TXT
> P3
> ------ ------------------------------ ------------- -------- --------
> ---------- ------------ -------- ------------- -------- ------
> -------
> 6 latch free WAITED KNOWN 0 -1
> address ############ number 34 tries
> 0
>
> latch# Name
> ------ ------
> 32 channel operations parent latch
Received on Fri Apr 01 2005 - 14:53:00 CST
