Re: How can I estimate the size necessary for archive log files ?

From: Frederic Payant <fpayant_at_club-internet.fr>
Date: Fri, 01 Mar 2002 23:03:52 +0100
Message-ID: <u2sv7u0cvt4i509prtca37k9pj7rvvf04q@4ax.com>

I apologize but I ask an ambiguous question.

What I would like to calculate is the volume of _online_redo_log that my database will generate when installed. (I made a confusion between archive logs and redo log)

The actual ativity is not representative as we are in development and our core product in a software on which we do not have many visibility.

I must find what volume of data will be generated in redolog files, assuming that I can estimate how many rows and of which size will be inserted/deleted/updated.
I suppose that because of indexes and all this sort of things, size of redolog will not be the sum of all these updates.

But is there any formula who could permit me to estimate this size ?

Any advise will be apreciated

Thanks by advance

Amicalement
Frédéric PAYANT Received on Fri Mar 01 2002 - 16:03:52 CST