| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Amount of redo
yechiel,
I didn't miss the comment, it's not relevant. Archived logs are merely copies of redo logs that have been filled. Whether or not archiving is turned on, redo logs get filled and reused. Oracle tracks the log switches no matter what mode you are in, it just doesn't make the copy of the redo log if you aren't in archive log mode.
So he can definitely track log switches in the alert log or in v$log_history. Given the number of switches in a week (this is approximately the number of archived logs that will be created), he can multiply that by the size of his largest redo log (hopefully they are all the same size but take the largest one if they are not). That will give him the maximum amount of space his archived logs will take in a normal week, barring any unusual load activity.
Now.... archived logs generally are NOT the full size of the redo logs so this will overestimate. But it's better to have too much space than too little
Rachel
--- Yechiel Adar <adar76_at_inter.net.il> wrote:
> Hello
>
> I do not think that you can estimate the amount of disk space
> required for
> archive log without turning archive log on and checking each day to
> see how
> much space you already used.
>
> To all who replied: I think that you missed his comment that
> currently he is
> NOT working with archive log on.
>
> Yechiel Adar
> Mehish
> ----- Original Message -----
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> Sent: Wednesday, August 14, 2002 2:08 PM
>
>
>
> Hi List,
>
> I want to put my databse in archive mode(Presently it is non archive
> mode).I want to estimate
> space that will be required for archive log taking we will be keeping
> one week archive on disk. How can i find out amount of redo generated
> in
> a week.
>
> Regards
> Pawan Dalmia
> Extn -5259
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Pawan Dalmia
> INET: Pawan.Dalmia_at_orange.co.in
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing
> Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Yechiel Adar
> INET: adar76_at_inter.net.il
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing
> Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: wisernet100_at_yahoo.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Thu Aug 15 2002 - 09:43:33 CDT
 |
 |