Re: What is the LOG_BUFFER values that people are running ??????

I miss read the Oracle doc (512kb not 512b).

Thank you for responding.

In article <1131029975.364647.80860_at_o13g2000cwo.googlegroups.com>, Mark.Powell_at_eds.com says...
>
>Wood, where in the Oracle documentation does it say 512 byte for the
>redo log buffer? Many shops probably oversize this parameter. From the
>9.2 Performance and Tuning Guide >> A reasonable first estimate for
>such systems is to make the log buffer 1 MB. On most systems, sizing
>the log buffer larger than 1m does not provide any performance benefit.
> << You can find the same information in the 8.1 and 10g versions of
>the manual.
>
>I think you will find many systems work fine with 512K bytes. On a
>heavy DML system 1M might be necessary.
>
>HTH -- Mark D Powell --
>
Received on Thu Nov 03 2005 - 09:11:24 CST