I sit corrected.
Yechiel Adar Mehish ----- Original Message ----- To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Thursday, August 15, 2002 4:43 PM > 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 <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> > > 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: [EMAIL PROTECTED] > > > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > > > 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: [EMAIL PROTECTED] (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). > > > __________________________________________________ > Do You Yahoo!? > HotJobs - Search Thousands of New Jobs > http://www.hotjobs.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Rachel Carmichael > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
