RE: Dataguard: Max Availability vs. Max Performance

  • From: Freeman Robert - IL <FREEMANR@xxxxxxxx>
  • To: 'Montgomerie Steve ' <steve.montgomerie@xxxxxxxxxxx>,"'oracle-l@xxxxxxxxxxxxx '" <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 14 Apr 2004 13:19:23 -0500

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@xxxxxxxxxxxxx
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@xxxxxxxxxxxx] 
Sent: Wednesday, April 14, 2004 12:29 PM
To: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: