Re: Very high 'log file sync' wait time with no 'log file parallel write' wait time

Jonathan Lewis wrote:
> I haven't followed this closely, but if you're
> seeing lots of waits for log file sync, but
> no waits for log file writes, then
>
> a) There used to be a bug in 9i which did not
> report the timing of log file writes properly -
> it's possible that this has slipped into your
> version of 10g.
>
> OR
>
> b) somehow your log file writer is using
> a variant of asynchronous I/O, so the log
> writer is dispatching a write request and
> sending an ACK to the front-end without
> having to wait for the write to complete.
>
>

Jonathan,

I continue to be curious about the origination of the "spurious" commits. If you look at the raw 10046 trace snippet Matt posted, they are all read only. What would cause this on an import?

Thanks,

Steve Received on Wed Nov 29 2006 - 10:48:19 CST