Re: determining ARCHIVELOG sizes

From: Jurij Modic <jmodic_at_src.si>
Date: Fri, 16 Jul 1999 22:07:29 GMT
Message-ID: <37909d31.1191664@news.siol.net>

On Fri, 16 Jul 1999 10:14:14 +0100, "Alex" <alex.hudghton_at_capgemini.co.uk> wrote:

>Each archive log will be the same size as the online redo logs, but how

Not necessarily. If the redo logs are switched before they are totally filled (e.g. with ALTER SYSTEM SWITCH LOGFILE or when shutting down the database), their corresponding archived logs will be smaller then the redo logs. However, I admit this are relatively rare situations compared to the normal database activity.

>often will they switch ?
>Depending on the frequency, you will need to compress / move / delete at
>appropriate rates.
>
>I think I prefer Connor's reply :-)
>
>Alex

Regards,
Jurij Modic <jmodic_at_src.si>
Certified Oracle DBA (7.3 & 8.0 OCP)

---

The above opinions are mine and do not represent any official standpoints of my employer Received on Fri Jul 16 1999 - 17:07:29 CDT