Re: ** latch free wait contention

From: Milen Kulev <>
Date: Tue, 08 Apr 2008 13:53:47 +0200
Message-ID: <>

Hello Joshi,
'latch free' is too nonspecific.
As Alex aleady said, you should dig further for more diagnostic information in order to be able to narrow the possible culprits.

When you see 'latch free' in v$session_wait.event (or v$session.event on 10G+), then P2 field has the same value as v$latch.latch# Then issue as statement like this :

select name from v$latch l where l.latch#=P2 and rownum=1 P2 is the value of v$session.P2 when v$session.EVENT ='latch free'.

HTH. Milen

  • Original-Nachricht --------
    > Datum: Mon, 7 Apr 2008 09:18:22 -0700 (PDT)
    > Von: A Joshi <>
    > An:
    > Betreff: ** latch free wait contention

> Hi,
> Can someone tell ways to improve latch free waits. It seems to be
> timing out a lot. Any parameters can be increased? Any relevant
> docs/url/info. Thanks
> ---------------------------------
> You rock. That's why Blockbuster's offering you one month of Blockbuster
> Total Access, No Cost.

GMX startet Hier findest Du Leute mit Deinen Interessen!
Jetzt dabei sein:
Received on Tue Apr 08 2008 - 06:53:47 CDT

Original text of this message