OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Redo log generation (oracle 9i on Unix)

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

Redo log generation [message #467697]

Mon, 26 July 2010 14:26

caprikar
Messages: 226
Registered: March 2007

Senior Member

Hi,
I have oracle 9i running on HP-UX, I would like to find how much redo we are generating in a given period of time, is there any script that I can use to get this information?
Thanks

Report message to a moderator

Re: Redo log generation [message #467698 is a reply to message #467697]

Mon, 26 July 2010 14:33

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

select * from v$log_history;

Report message to a moderator

Re: Redo log generation [message #470072 is a reply to message #467697]

Sat, 07 August 2010 22:08

zouxiangdong
Messages: 3
Registered: July 2010

Junior Member

you can select name "redo size" in the v$sysstat view at the start time and end time.

Report message to a moderator

Re: Redo log generation [message #470078 is a reply to message #470072]

Sun, 08 August 2010 00:27

Michel Cadot
Messages: 68653
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

This is limited to the instance life, if you want information across instances you have to use v$loghist view.

Regards
Michel

Report message to a moderator

Previous Topic:	Why archive should be turned ON before turning on flashback (2 threads merged by bb)
Next Topic:	Which way can I choose?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon May 20 00:12:12 CDT 2024