Increasing Redo Log File size doesn't help with log switch frequency?
We are in a RAC environment with two nodes, on version Oracle 11.2.0.4 and archiving is on.
We have totally 16 Redo groups, 8 for each instance. I ran this script to check log switch frequency
set lines 120;
set pages 999;
SELECT to_char(first_time,'YYYY-MON-DD') day,
to_char(sum(decode(to_char(first_time,'HH24'),'00',1,0)),'99') "00",
to_char(sum(decode(to_char(first_time,'HH24'),'01',1,0)),'99') "01",
to_char(sum(decode(to_char(first_time,'HH24'),'02',1,0)),'99') "02",
to_char(sum(decode(to_char(first_time,'HH24'),'03',1,0)),'99') "03",