Oooh, that's a keeper. :)
Jared
[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
05/27/2003 10:50 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
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 : [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).
--
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).
