Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle Stats Tuning Question
Cool. Thanks again. We will give it a try.
Sybrand Bakker wrote:
> On 22 Sep 2005 11:32:15 -0700, stockcar_at_gmail.com wrote:
>
> >Thanks for the response. The log_buffer is set to 67108864.
>
> Yes, that was what I more or less suspected. Increasing the log buffer
> beyond measure in my experience often results to log file sync
> problems.
> Personally I usually set it at 512k, or 1M maximum.
> You would want the LGWR to 'dribble', not to 'burst' dirty data to
> disk.
>
>
> --
> Sybrand Bakker, Senior Oracle DBA
Received on Thu Sep 22 2005 - 15:12:29 CDT