Database Administration (MOSC)

MOSC Banner

What is a appropriate size for a redo log file?

edited Jul 22, 2009 5:05AM in Database Administration (MOSC) 9 commentsAnswered ✓
 Hi,

I understand that a too small redo log file will cause lots of log switching and disk wrting which reduces server performance.  What are the drawbacks of a too large redo log file? Is there a rule of thumb in figuring out the file size?

Thanks,

Simon

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