Re: ** latch free wait contention

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 <ajoshi977_at_yahoo.com>
  > An: oracle-l_at_freelists.org
  > 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 ShortView.de. Hier findest Du Leute mit Deinen Interessen!
Jetzt dabei sein: http://www.shortview.de/?mc=sv_ext_mf@gmx
--
http://www.freelists.org/webpage/oracle-l