Home » RDBMS Server » Server Administration » Log Buffer Size
Log Buffer Size [message #197666] Thu, 12 October 2006 04:19 Go to next message
M.Shakeel Azeem
Messages: 226
Registered: September 2006
Senior Member
execute the following script
SQL> @c:\sga_statistics.sql;

PL/SQL procedure successfully completed.

SQL> set serveroutput on;
SQL> /
> ********************
> SQL Cache Hit rate = 99.24
> Dict Cache Hit rate = 99.67
> Buffer Cache Hit rate = 99.88
> Redo Log space requests = 1440
> ****************
> Shared Pool Size = 52428800 Bytes
> DB Block Buffer = 32768 Blocks
> Log Buffer = 20971520 Bytes
*** HINT: Log Buffer value is rather low!

should i have to increase the size of log_buffer Because Redo Log space requests = 1440 is high?
What u'll suggest Sir?
thanx in advance
Re: Log Buffer Size [message #197706 is a reply to message #197666] Thu, 12 October 2006 06:48 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
For several years now, we have been repeatedly saying in this forum
Definitely, they do mean something. But it is not a measure of performance.
>>should i have to increase the size of log_buffer
Is there any rationale you are applying here?

Rarely a database needs a log_buffer more than 1Mb (Optimal in many cases is 512k. But let us not generalize anything here).
Because, log buffer is flushed every 3 seconds or after every commit or when it gets full to some threshold.
So the question is ,
does the database generate/handle more than 1 Mb worth records every 3 seconds?
Previous Topic: Oracle Clusterware and RAC database 10.2 installation
Next Topic: DBMS_JOB
Goto Forum:

Current Time: Sat Oct 22 16:53:20 CDT 2016

Total time taken to generate the page: 0.22339 seconds