Redo Log Volume [message #508516] |
Sun, 22 May 2011 16:10 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/b799cf7e40d5b3fbdd9bc0af3b46ef88?s=64&d=mm&r=g) |
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 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
John Watson
Messages: 8937 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);
|
|
|