RE: Dataguard: Max Availability vs. Max Performance

From: Freeman Robert - IL <FREEMANR_at_tusc.com>
Date: Wed, 14 Apr 2004 13:19:23 -0500
Message-ID: <F5E885BEF9540D47A7BDC03CF1688087066D6745@tuscil_ex1>

Exactly, and in fact I've seen that be a huge problem in past dataguard implimentations. In one case, the lack of performance because of network and distance related issues required a complete rework of the overall architecture.

Robert

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

From: Montgomerie Steve
To: oracle-l_at_freelists.org
Sent: 4/14/2004 11:43 AM
Subject: RE: Dataguard: Max Availability vs. Max Performance

What if your standby was 500 miles away and you network was not superfast/infalable? Oracle won't return a commit until the change is available on the standby
Steve Montgomerie
PeopleSoft/Oracle Administrator
SIEMENS Shared Services, LLC

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

From: Weaver, Walt [mailto:wweaver_at_rightnow.com] Sent: Wednesday, April 14, 2004 12:29 PM To: oracle-l_at_freelists.org
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

Binary/unsupported file stripped by Ecartis --
Type: application/octet-stream
File: Montgomerie Steve.vcf

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 - 13:16:30 CDT