On Wed, Jun 20, 2012 at 10:48 PM, Prasad Reddy Subbella < Prasad_Subbella@xxxxxxxxxxx> wrote: > Hi All, > Please share/guide me the best practices to be used for sizing redo log > files. > > > Here's one: Make sure that the time required to cycle through all (N-1) redo files is less than the time it takes to have the archivelogs created for (N-1) redo logs. This should ensure that the archiver will not bump into the redo. (please correct math if wrong, I am tired) Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist Oracle Blog: http://jkstill.blogspot.com Home Page: http://jaredstill.com -- //www.freelists.org/webpage/oracle-l