Re: Redo Log File Sizes

25MB might be too big or too small for your database. It all depends on the characteristics of your database.
To answer your question, no...If too small, Oracle will complain in the alert<sid>log file and performance will be on a low end. I've worked with databases where, depending on the business needs of the database, I had redo logs of anywhere from 2MB-100MB.

Satar

In article <71l6ol$mo9$1_at_nnrp1.dejanews.com>,   rspeaker_at_my-dejanews.com wrote:
> I decided to set up a new Oracle installation with 25MB redo logs, for no
> particular reason. Does anyone know of any reasons that redo log files of
> this size would cause any problems (before I put it into production) ??
>
> Thanks.
> Roy
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>

--
Oracle DBA/UNIX System Admin
Advanced Enterprise Solutions
(949) 756-0588
Oracle Re-Seller

-----------== Posted via Deja News, The Discussion Network ==----------
http://www.dejanews.com/       Search, Read, Discuss, or Start Your Own