Small Redo Log File Size

From: Dereck L. Dietz <dietzdl_at_ameritech.net>
Date: Tue, 15 Aug 2006 23:17:25 GMT
Message-ID: <9CsEg.9498$9T3.9241@newssvr25.news.prodigy.net>

I'm working with an Oracle 10g Version 1.0 datawarehouse database upgraded from an Oracle 9i version.

While running the Enterprice Manager and browsing through the performance recommendations I came across one which stated the Redo Log Files were too small. The size of the current Redo Log Files (3 groups of only 1 file each) are only 10MB. Oracle recommended the size of 2GB for the Redo Log Files.

Since we've experienced very slow response times the more activity there is against the database I think this should be taken seriously. I'm expecting resistance - or apathy - when I suggest following this recommendation.

Since I'm not the "official" DBA there (and a contractor to boot) I'd like to have as much ammunition as possible to back up my suggestion.

Would it be possible for the more knowledgeable on this group to post about the benefits of properly sized Redo Log Files and the pitfalls of improperly sized Redo Log Files? I'd like to be able to print them out to use if I have resistance to this recommendation.

Thanks. Received on Tue Aug 15 2006 - 18:17:25 CDT