RE: performance impact of archivelog

From: Roberts, David (GSD - UK) <>
Date: Mon, 17 Nov 2008 11:09:24 +0000
Message-ID: <>

  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  

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-----

[] On Behalf Of Claudia Zeiler Sent: 15 November 2008 21:27
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


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.

-- Received on Mon Nov 17 2008 - 05:09:24 CST

Original text of this message