Redo log generation [message #467697] |
Mon, 26 July 2010 14:26 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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
|
|
|
|
|
Re: Redo log generation [message #470078 is a reply to message #470072] |
Sun, 08 August 2010 00:27 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68665 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
|
|
|