covering both fast and slow redo log switches
Hi,
I'm having the following actual problem : on a given database, I'm seeing plenty of redo log switches. All seems OK there.
But, almost all of these switches happen during a very specific time of the day. Let's say in a period of about 4 hours, and outside of working hours.
Apart from that busy period, there is almost no redo log switch happening. That means : 1 or 2 switches, which then means for a period of about 20 hours.
So, shortly said : I have hundres of switches during 4 hours, I have 1 or 2 switches for the rest of the day.
The problem is : if I look at the working hours period only, my conclusion is : there is not enough switches. Mathematical : 1 or 2 for 20 hours, which is one every 20 or every 10 hours. I would like more switches. It can be done by making the redos smaller (which is the obvious solution) ...