Re: ** latch free wait contention

Hi Milen,

     Yes. Iam following up on the specific slow operations also. After reading Alex replies. I would still like to know what these and log file sync waits mean and all possible ways to tackle them. If something like some param not right. Or something else missing. Thanks

Milen Kulev <makulev_at_gmx.net> wrote: 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: 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




       
---------------------------------
You rock. That's why Blockbuster's offering you one month of Blockbuster Total Access, No Cost.
--
http://www.freelists.org/webpage/oracle-l