Chuck wrote:
> 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.
And consider how long you allow the system to continue when this
filesystem is filled up. Oracle will use the online redo logs until
it hits a non-archived one. The it stops transactions.
Create as many, and as large, to allow for a good night of sleep.
--
Regards, Frank van Bortel
Received on Mon Apr 28 2003 - 16:01:08 CDT
