Quote Originally Posted by ixion
I'd leave your log file alone at 100mb... If the db is generating more than 1 archive file per say 10 - 20 minutes.. then its time to increase the size.
Not picking on you, but I'm genuinely curious, is the 10-20 minute window for reasonable recovery .. Ex. "can't afford to loose up to 20 minutes of transactions"?

What are the ramifications of time based vs. size based logging?

I've heard that the redo should be larger for RAC. Is that true?

Ken