Database Administration (MOSC)

MOSC Banner

Increasing Redo Log File size doesn't help with log switch frequency?

edited Jun 7, 2017 2:06PM in Database Administration (MOSC) 7 commentsAnswered ✓

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",

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