RE: performance impact of archivelog

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

--
http://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.


--
http://www.freelists.org/webpage/oracle-l

Other related posts: