Redo Log Volume [message #508516] |
Sun, 22 May 2011 16:10 |
|
ryanpj
Messages: 3 Registered: May 2011
|
Junior Member |
|
|
I was asked by my systems administrator if I could tell him how much redo log volume, on average, do I figure we generate in a day?
Just wondering how I might calculate this?
We have several production databases. If I wanted to calculate the above for one of them, would it be take all the redo logs for a day and total up the size in bytes? Maybe take a 5 day work week and take the average over the 5 days?
any help would be greatly appreciated.
Thanks
|
|
|
|
|
|
Re: Redo Log Volume [message #508520 is a reply to message #508519] |
Sun, 22 May 2011 16:54 |
John Watson
Messages: 8944 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
Slight variation on BS's query, to give you some historical information:
select trunc(first_time) WHEN, sum(round(blocks*block_size/(1024*1024)))
from v$archived_log group by trunc(first_time);
|
|
|