Re: Redo generation rate

Oooh, that's a keeper. :)

Jared

tim_at_sagelogix.com
Sent by: root_at_fatcity.com
 05/27/2003 10:50 AM
 Please respond to ORACLE-L  

        To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
        cc: 
        Subject:        Re: Redo generation rate

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: 
  INET: Jared.Still_at_radisys.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).