Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Very high 'log file sync' wait time with no 'log file parallel write' wait time
> Why are you specifying "commit=y" for imp? If you set commit=n, a
> commit will be performed after each object is fully imported, rather
> than after the number of rows that will fit into the buffer
> (buffer=20000000 specification) The special cases outlined by Steve
> Howard still apply.
To avoid unneccessarily increasing the undo tablespace....
Matt Received on Tue Nov 28 2006 - 04:59:52 CST