Estimating Frequency of redolog switch

Hi everyone,

I running Oracle 9i

To size the space needed on disks I use to store archivelog between two backups, I need to estimate how fast redolog will be filled on my plateform

Assuming I know

• what kind of transaction is made on my base, typically the update of one or two int field in a 1024 bytes rows
• the average frequency of these transaction
• the size of my redologs

Is it easy to calculate how often I will switch of redolog?

Is there a tool to dig inside redolog or archivelog in order to see clearly how big is a transaction in these file?

For your information, I made some simulation, updating only one int into a 1024 bytes long row of ints and strings, committing every 10 or 50 times. The estimated average size of the transaction in redolog would be 1024 bytes!

What do you think of the pertinence of that result?

Thanks in advance

Samuel. Received on Fri Mar 28 2003 - 11:12:19 CET