Re: Number of Redo Log Files

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 ----- From: <Yerpude_at_btnl.com> To: <ORACLE-L_at_fatcity.com>; <oracledba_at_quickdoc.co.uk> Sent: Thursday, June 01, 2000 1:13 PM Subject: Number of Redo Log Files

> 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
Received on Thu Jun 01 2000 - 05:30:33 CDT