Re: which latch?

From: <bchorng_at_my-deja.com>
Date: 2000/03/30
Message-ID: <8c0ik9$rbh$1@nnrp1.deja.com>#1/1

In article <8c0ho0$q9i$1_at_nnrp1.deja.com>, robertchung0909_at_my-deja.com wrote:
>
>
> This maybe very simple question. I had a session waiting for latch to
> free as shown below, but I do not know what kind of latch that is. Is
> there some way to find it? Thank you in advance.
>
> SID SEQ# EVENT
> ---------- ----------

---

> --------------
> P1TEXT
> P1 P1RAW
> ----------------------------------------------------------------

---

> --- --------
> P2TEXT
> P2 P2RAW
> ----------------------------------------------------------------

---

> --- --------
> P3TEXT
> P3 P3RAW WAIT_TIME SECONDS_IN_WAIT
> ----------------------------------------------------------------

---

> --- -------- ---------- ---------------
> STATE
> -------------------
> 14 9282 latch free
> address
> 435691304 19F81F28
> number
> 60 0000003C
> tries
> 1 00000001 1 10
> WAITED KNOWN TIME
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Map your p2 against v$latch.latch#. In your case, it is library cache ( 60 ).

-Bass Chorng

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Mar 30 2000 - 00:00:00 CST