Home » RDBMS Server » Backup & Recovery » Redo Log Volume (10g R2 Solaris)
Redo Log Volume [message #508516] Sun, 22 May 2011 16:10 Go to next message
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 #508517 is a reply to message #508516] Sun, 22 May 2011 16:19 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10629
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Are you talking about the archived log volume or really mean redolog volume?
Re: Redo Log Volume [message #508518 is a reply to message #508516] Sun, 22 May 2011 16:20 Go to previous messageGo to next message
BlackSwan
Messages: 23035
Registered: January 2009
Senior Member
select trunc(first_time) WHEN, sum(round(bytes/(1024*1024))) from v$log group by trunc(first_time);

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/
Re: Redo Log Volume [message #508519 is a reply to message #508518] Sun, 22 May 2011 16:27 Go to previous messageGo to next message
ryanpj
Messages: 3
Registered: May 2011
Junior Member
Hi Manish, I'm not sure. I received the email late on Friday. All it specified was redo log volume.

Thanks BlackSwan, I will give it a try.

For future posts, what guidelines did I miss? my apologies.
Re: Redo Log Volume [message #508520 is a reply to message #508519] Sun, 22 May 2011 16:54 Go to previous message
John Watson
Messages: 4793
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);

Previous Topic: corrupted files(2 Merged)
Next Topic: Flash Recovery Area 9i
Goto Forum:
  


Current Time: Mon Nov 24 01:08:11 CST 2014

Total time taken to generate the page: 0.28468 seconds