Originally posted by pareshg
Hello Guys,

I am checking server statistics in TOAD which is showing Redo Space Wait Ratio = 199.09. What does it mean exactly ?

Oracle 8.1.7 on Win NT.
I have 4 redolog files of 10MB each.

Regards

Paresh
4 redolog files? Is this 2 groups each with 2 members or 4 groups each with exactly one member?

The wait indicates the time spent on waiting on disk space to be allocated for redo.

Do as Stantcho suggested.

What values do you have for LOG_CHECKPOINT_INTERVAL and LOG_CHECKPOINT_TIMEOUT?