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

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 - 08:59:35 CST