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
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.comSan 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.comSan 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).
