Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: intermittent very high waits in LGWR on Linux?

Re: intermittent very high waits in LGWR on Linux?

From: Noons <wizofoz2k_at_yahoo.com.au>
Date: Thu, 30 Jun 2005 21:15:28 +1000
Message-ID: <42c3d44b$0$8651$5a62ac22@per-qv1-newsreader-01.iinet.net.au>


bugbear apparently said,on my timestamp of 30/06/2005 8:49 PM:
>
> But 7% of the waits (332 of them) are
> almost exactly 1 second each.
>
> It's almost as if these syncs are being
> done on a clock, as opposed to "on demand".
>
> Bizarrely, if a attempt to diagnose the LGWR
> process by attaching an strace(1) to it,
> it goes around 5x faster!!!
>
> Has anyone seen anything like this?

strace? This is Linux? If so, please:
OS version, patch levels, h/w details and file system being used. Also like I said in the other reply: init.ora parameters.
For both 9i and 10g.

-- 
Cheers
Nuno Souto
in wet Sydney, Australia
wizofoz2k_at_yahoo.com.au.nospam
Received on Thu Jun 30 2005 - 06:15:28 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US