Re: Redo/Archive Log File System Size??

On Mon, 28 Apr 2003 21:02:06 +0200, Martijn wrote:

> G'day,
>
> The company I work for plans to run Oracle Applications (just the Financials
> module) and two other separate database environments on the same system (AIX
> Unix P650).
>
> I know this is hard to say, but could anyone maybe give a ballpark estimate
> of how much Redo Log/Archive Log data Oracle Applications will generate 'on
> average'?
>
> Will a File System of about 31GB be enough to hold the Redo Log and Archive
> Log data?
>
> Thanks for your help :)
> martijn

Depends on the transaction rate, how often you want to run a backup/purge of the logs, and if the file system is to be used for anything else. Most likely 31g will be enough. The only way to know for sure however is to test it under a production load. See how much log data you generate over a given period of time. That will tell you the minimum frequency for backup/purge. You'll probably want to do this at least daily. More often if you are concerned about losing archived log files. Received on Mon Apr 28 2003 - 14:26:50 CDT