Need advise for tuning Oracle redo log files settings in 11.2.0.4 database.
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
---------- ---------- ---------- ---------- ---------- ---------- ---