Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: determining ARCHIVELOG sizes
The poster of this question clearly stated he was looking for a method to
calculate the space required to hold archive logs. The safest assumption in
this case is to assume that all archived logs are of the maximum size. If
there are any that are smaller (and of course there will be) then they will
still fit into the space allocated
Alex :-)
Jurij Modic wrote in message <37909d31.1191664_at_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 Mon Jul 19 1999 - 02:10:35 CDT