Hello,
After migrating to 11g, we have noticed checkpoint is not complete during intensive batch jobs.
It basically means that Oracle 11g is gummier in redo size than 10g.
Notes 79341 specifies that, when the interval between log switch is less than 1 minute,
we should increase the redo size.
When the interval is higher than one minute, we should increase the redo groups number.
Could you explain me why?
I would be tempted to say that small redo size would force a checkpoint faster.
Therefore, with fast redo switch, it would be better to have a small redo size.
Thanks in advance for your answer.