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@xxxxxxxxxxxxx To: oracle-l@xxxxxxxxxxxxx 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 __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l