Hi, list. I'm with the same doubt... We have a Data Warehouse database in "no archivelog" mode with 180GB/day of redo generation. because of a new backup solution/ strategie, we need put it in "archivelog ON". Claudia, Have you any other information about it ? Thanks a lot! Renato Gomes Eds, an HP Company. On Mon, Nov 17, 2008 at 9:09 AM, Roberts, David (GSD - UK) < david.h.roberts@xxxxxxxxxx> wrote: > 1. Performance cost of running in archivelog mode. > > We take our database out of archive log mode for a yearly batch process. > Very roughly the dry run (which is run on a different but similarly > specked machine in archive log mode) takes about 20% longer. > > Obviously as the difference is going to be dependent on how much change > is going on, your mileage may vary. > > > David Roberts > www.logica.com > > Logica UK Limited > Registered in England and Wales (registered number 947968) > Registered office: Stephenson House, 75 Hampstead Road, London NW1 2PL, > United Kingdom > > -----Original Message----- > From: oracle-l-bounce@xxxxxxxxxxxxx > [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Claudia Zeiler > Sent: 15 November 2008 21:27 > To: oracle-l@xxxxxxxxxxxxx > Subject: performance impact of archivelog > > Has anyone on the list seen a discussion of > > 1. performance cost of running in archivelog mode. > 2. overhead of using partitions > 3. time calculation to perform statistics > 4. time savings of using statistics > > I always see these things discussed in terms of "more" but never in > terms of "how much". > > Thanks for any information that you can point me to. > > > Claudia Zeiler > > -- > //www.freelists.org/webpage/oracle-l > > > > > This e-mail and any attachment is for authorised use by the intended > recipient(s) only. It may contain proprietary material, confidential > information and/or be subject to legal privilege. It should not be copied, > disclosed to, retained or used by, any other party. If you are not an > intended recipient then please promptly delete this e-mail and any > attachment and all copies and inform the sender. Thank you. > > > -- > //www.freelists.org/webpage/oracle-l > > >