Samir, I find this query useful...
select first_time, mb, mb - (avg(mb) over ()) dev_from_avg from (select trunc(first_time) first_time, sum(blocks*block_size)/1048576 mb from v$archived_log group by trunc(first_time)) order by first_time; Hope this helps.... -Tim > All, > > Can anybody please help me on this : > > We are trying to find out the bandwidth required for > keeping our DR database updated using Dataguard. > There is an equation the networking guys use for this but > I need to give them the redo generation rate > or redo copy rate in bytes per second. Is there any way I > can find this out without using Statspack ?? > > Thanks and Regards, > > Samir > > Samir Sarkar > Oracle DBA > SchlumbergerSema > Email : [EMAIL PROTECTED] > Phone : +44 (0) 115 - 957 6028 > EPABX : +44 (0) 115 - 957 6418 Ext. 76028 > Fax : +44 (0) 115 - 957 6018 > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.net -- > Author: SARKAR, Samir > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 > http://www.fatcity.com San Diego, California -- > Mailing list and web hosting services > ---------------------------------------------------------- > ----------- To REMOVE yourself from this mailing list, > send an E-Mail message to: [EMAIL PROTECTED] (note > EXACT spelling of 'ListGuru') and in the message BODY, > include a line containing: UNSUB ORACLE-L (or the name of > mailing list you want to be removed from). You may also > send the HELP command for other information (like > subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).