RE: Dataguard: Max Availability vs. Max Performance

From: Freeman Robert - IL <FREEMANR_at_tusc.com>
Date: Wed, 14 Apr 2004 11:34:21 -0500
Message-ID: <F5E885BEF9540D47A7BDC03CF1688087066D6743@tuscil_ex1>

Much of this is dependent on the networking to your remote site and it's speed and ability to handle the volume and velocity of transactions. If you are running 28.8kb modem, for example, you would probably see terrible performance, t-3's and so on fare better. Distance is also an issue, for the same reasons.

HTH, Robert
Author
Oracle 10g Database New Features
Oracle9i RMAN Backup and Recovery

-----Original Message-----

From: Weaver, Walt
To: oracle-l_at_freelists.org
Sent: 4/14/2004 11:28 AM
Subject: Dataguard: Max Availability vs. Max Performance

I'm setting up a Dataguard configuration (Dell 6650's, RedHat AS 3.0, 9.2.0.4) and was curious about the statement in the Dataguard Concepts and Administration manual stating that Max Availibility "presents a potential response time degradation".
I am aware of why there might be a performance degradation, but I was wondering if anyone was using Dataguard with Max Availability. If so, have you seen any kind of degradation?

Are there any metrics around showing what the potential degradation might be? The primary machine in our Dataguard configuration will be the back-end of a hosted web site and will be serving up about 2.5 million page turns a month.

Is there any way I can determine what sort of performance hit will occur if I set Dataguard to Max Availability?

The customers on this machine are really anal about performance for some reason and I don't want to make'em mad.

Thanks,

--Walt Weaver

Bozeman, Montana

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/

FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html


-----------------------------------------------------------------

----------------------------------------------------------------

Please see the official ORACLE-L FAQ: http://www.orafaq.com


----------------------------------------------------------------

To unsubscribe send email to:  oracle-l-request_at_freelists.org

put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

Received on Wed Apr 14 2004 - 11:34:33 CDT