Database Administration (MOSC)

MOSC Banner

covering both fast and slow redo log switches

edited Jul 6, 2015 10:57AM in Database Administration (MOSC) 11 commentsAnswered ✓

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) ...

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