Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: intermittent very high waits in LGWR on Linux?
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.nospamReceived on Thu Jun 30 2005 - 06:15:28 CDT