Database Tuning (MOSC)

MOSC Banner

Optimal Size and Number of redo logs

edited Aug 9, 2011 2:30AM in Database Tuning (MOSC) 8 commentsAnswered ✓

Hi all,

I'd like to get your advise on what should be the optimal size of redo logs and how many redo logs should I  have. I have been getting huge number of checkpoint errors. And I know I needed to resize my redo logs.

This his how my archive file looks like - noting the fast rotation in between redo logs. Will 250MB x 5 redo logs solve my problem?

thanks!

-rw-r----- 1 oracle oinstall 47191040 Aug  4 02:00 1_49627_712591488.dbf
-rw-r----- 1 oracle oinstall 46637056 Aug  4 02:00 1_49628_712591488.dbf
-rw-r----- 1 oracle oinstall 46637056 Aug  4 02:00 1_49629_712591488.dbf
-rw-r----- 1 oracle oinstall 46637056 Aug  4 02:00 1_49630_712591488.dbf
-rw-r----- 1 oracle oinstall 46637056 Aug  4 02:00 1_49631_712591488.dbf
-rw-r----- 1 oracle oinstall 46637056 Aug  4 02:00 1_49632_712591488.dbf

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