Database Administration (MOSC)

MOSC Banner

Need advise for tuning Oracle redo log files settings in 11.2.0.4 database.

edited Sep 22, 2015 10:50AM in Database Administration (MOSC) 7 commentsAnswered ✓

Hi:  we run a few times Volume Tests and  get STATSPACK report.  Each time wait events from 'log files' keep surfacing to 'top 5 wait events'.  I understand there are always 'top 5 wait events' but really want to tune redo log settings.  our system is congested on 'redo logs' .

here is our DB settings for 'redo logs' get at normal office hour:


SQL> SELECT BLOCKSIZE FROM V$LOG;

BLOCKSIZE
----------
       512

SQL> SELECT name, value FROM v$sysstat WHERE name = 'redo wastage';

NAME                                                                  VALUE
---------------------------------------------------------------- ----------
redo wastage                                                      171462448

SQL> select * from v$log;

    GROUP#    THREAD#  SEQUENCE#      BYTES  BLOCKSIZE    MEMBERS ARC
---------- ---------- ---------- ---------- ---------- ---------- ---

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