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: Oracle Stats Tuning Question

Re: Oracle Stats Tuning Question

From: <stockcar_at_gmail.com>
Date: 22 Sep 2005 13:12:29 -0700
Message-ID: <1127419949.800292.135370@g14g2000cwa.googlegroups.com>


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

Original text of this message

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