Re: Number of Redo Log Files

Lalit,

Not really, the negative performance effect will potentially be experienced on "frequent checkpoints" rather than the archiver process trying to copy larger files. Having said that the performance of the archiver can also be tuned by setting the log_archive_buffers and log_archive_buffer_size parameters to the platform-specific allowed maximum. Further, you have to ensure that there is minimal contention between the disk volumes where the online redo logs are placed and where log_archive_dest points to.

Best Regards,

Gaja.

• Yerpude_at_btnl.com wrote:
  >
  > Hi Sergey,
  > Thanks for reply. Currently the redologs are sized to
  > 100MB, and
  > during heavy processing the log switch occurs within two to
  > three minutes.
  > Will not the increase in size of the logfiles take more time
  > in copying the
  > redolog files by archiving process, further effecting the
  > performance.
  >
  > With Warm Regards
  >
  > Lalit Kumar Yerpude
  > Bharti TeleNet Limited.
  > Bhopal (M.P.) Pincode : 462003
  > Tel : (O) 91-755-200251,252
  > (R) 91-755-293329
  > E-mail: yerpude_at_btnl.com; yerpude_at_hotmail.com
  >
  <><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><>
  >
  >
  >
  >
  >
  > "Sergey
  >
  > Stapeyev" To:
  > <ORACLE-L_at_fatcity.com>,
  > <stapsg_at_volog
  > <oracledba_at_quickdoc.co.uk>, <Yerpude_at_btnl.com>
  > da.cbr.ru> cc:
  >
  > Subject: Re:
  > Number of Redo Log Files
  > 06/01/00
  >
  > 03:34 PM
  >
  >
  >
  >
  >
  >
  >
  >
  >
  > How frequently your database switch logfiles?
  > If you have a switch in < 10 min it could cause a performance
  > bottleneck
  > because of checkpoints.
  > In this case it is more wise to increase size of logfiles.
  >
  >
  > Serguei.
  >
  > ----- Original Message -----
  > To: <ORACLE-L_at_fatcity.com>; <oracledba_at_quickdoc.co.uk>
  > Sent: Thursday, June 01, 2000 1:13 PM
  >
  >
  > > Hi,
  > > Currently my application is having 9 redo logs files of
  > 100MB each
  > and
  > > the database is in archivelog mode. When updating a large
  > table lots of
  > > logs are generated and the archivelog process cannot compete
  > to backup
  > the
  > > last log. I am planning to add more number of logs and make
  > it to around
  > > 15. Are there any implecations or limitations on the number
  > of logs ????
  > >
  > > With Warm Regards
  > >
  > > Lalit Kumar Yerpude
  > > Bharti TeleNet Limited.
  > > Bhopal (M.P.) Pincode : 462003
  > > Tel : (O) 91-755-200251,252
  > > (R) 91-755-293329
  > > E-mail: yerpude_at_btnl.com; yerpude_at_hotmail.com
  > >
  >
  <><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><>
  > >
  > >
  > >
  > > --------
  > > If you're bored, then visit the list's website:
  > http://www.lazydba.com
  > (updated daily)
  > > to unsubscribe, send a blank email to
  > oracledba-unsubscribe_at_quickdoc.co.uk
  > > to subscribe send a blank email to
  > oracledba-subscribe_at_quickdoc.co.uk
  >
  >
  >
  >
  >
  > --
  > Author:
  > INET: Yerpude_at_btnl.com
  >
  > Fat City Network Services -- (858) 538-5051 FAX: (858)
  > 538-5051
  > San Diego, California -- Public Internet access /
  > Mailing Lists
  >
  

  ---

  
  > To REMOVE yourself from this mailing list, send an E-Mail
  > message
  > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru')
  > and in
  > the message BODY, include a line containing: UNSUB ORACLE-L
  > (or the name of mailing list you want to be removed from).
  > You may
  > also send the HELP command for other information (like
  subscribing).

  ---

Gaja Krishna Vaidyanatha   | 3460 West Bayshore Road,
Manager - Integration      | Palo Alto, CA 94303
& Consulting Services      | gaja_at_brio.com
Global Alliances           | (650)-565-4442
Brio Technology            | www.brio.com 

"Opinions and views expressed are my own and not of Brio Technology"