OraFAQ Forum: Backup & Recovery

Home » RDBMS Server » Backup & Recovery » Redo Log Volume (10g R2 Solaris)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

Report message to a moderator

Re: Redo Log Volume [message #508517 is a reply to message #508516]

Sun, 22 May 2011 16:19

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Are you talking about the archived log volume or really mean redolog volume?

Report message to a moderator

Re: Redo Log Volume [message #508518 is a reply to message #508516]

Sun, 22 May 2011 16:20

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

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/

Report message to a moderator

Re: Redo Log Volume [message #508519 is a reply to message #508518]

Sun, 22 May 2011 16:27

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.

Report message to a moderator

Re: Redo Log Volume [message #508520 is a reply to message #508519]

Sun, 22 May 2011 16:54

John Watson
Messages: 8929
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);

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 18 02:28:33 CDT 2024