| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: question on standby (LGWR, ASYNC)
The biggest issue I've seen is with network latency. Remove that and you
have solved half the problem. You need the fastest connection you can get
between the two systems. Generally the standby server/database itself is not
the bottleneck, unless it's just woefully underpowered, or being used for
other things.
Robert
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
To: oracle-l_at_freelists.org
Sent: 9/20/2004 1:42 PM
Subject: question on standby (LGWR, ASYNC)
Hi,
I'm trying to understand the performance impact the
standby database will have on the primary database
with Maximum Performance mode (LGWR ASYNC using
standby redo logs) if the physical standby is not
able to handle the load generated by the primary db.
Will there be any?
I read somewhere on metalink that when the LNS detects that the async network buffer is full, the primary db will halt for a number of seconds before temporary switching to ARCH for shipping the logs. Is there a best practice as to what I should set the async network buffer (ASYNC) to?
I'm using 9204.
TIA. susan
 |
 |