Database Tuning (MOSC)
MOSC Banner

REDO LOG BUFFER

edited Jun 17, 2012 7:57PM in Database Tuning (MOSC) 4 commentsAnswered
Hi everyone,
My database is 10.2.0.5.0 standard edition having running on windows server 2008 32-bit.
My database is showing these statistic,GOOGLE told me increase the size of redo log buffer:-

SQL>   SELECT name, value FROM SYS.v_$sysstat
  2       WHERE NAME in ('redo buffer allocation retries','redo wastage',
  3                      'redo log space wait time','redo log space requests');

NAME                                                                  VALUE
---------------------------------------------------------------- ----------
redo buffer allocation retries                                         1251
redo wastage                                                       49103144
redo log space requests                                                 348
redo log space wait time                                               4473

my SGA is:-
SQL> sho sga

Total System Global Area  612368384 bytes
Fixed Size                  1304752 bytes
Variable Size             171968336 bytes
Database Buffers          436207616 bytes
Redo Buffers                2887680 bytes

plz help me,should i need to increase the size of redo log buffer only or i need to increase the size of SGA.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center