Re: channel operation parent latch

From: maks <maks70_at_comcast.net>
Date: 1 Apr 2005 11:38:05 -0800
Message-ID: <1112384285.148413.15620@l41g2000cwc.googlegroups.com>

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 - 13:38:05 CST