Re: performance impact of archivelog

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_at_logica.com> 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_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Claudia Zeiler
> Sent: 15 November 2008 21:27
> To: oracle-l_at_freelists.org
> 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
>
>
>

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