Optimal Size and Number of redo logs
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 |