Minutes = each redo switch time difference.Not always, but very often the time diff is only 3 -4 minutes.

No I did not get any "checkpoint not complete" error.

But I am thinking about Load of redo switch. Frequent redo switch has lot of overheads and performance can degrade since each datafile will be frozen during each redo switch.

What do you suggest?


Regards