RE: Redo generation rate

Tim,

Thanks so much for your response.....ur query was of immense help.

Cheers

Samir

-----Original Message-----
Sent: 27 May 2003 18:50
To: Multiple recipients of list ORACLE-L

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 : ssarkar2_at_slb.com
> 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: Samir.SARKAR_at_nottingham.sema.slb.com
>
> 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: ListGuru_at_fatcity.com (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: tim_at_sagelogix.com

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: ListGuru_at_fatcity.com (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: SARKAR, Samir
  INET: Samir.SARKAR_at_nottingham.sema.slb.com

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: ListGuru_at_fatcity.com (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).