Hi Susan, I'm in the middle of the research for a paper about Data Guard performance issues, that I will present at Miracle's DBF and UKOUG in October/November. This is one of the topics under investigation, but still on the to do list. If I forget, don't hesitate to remind me somewhere in the second half of October, to provide you with some metric. Best regards, Carel-Jan Engel === If you think education is expensive, try ignorance. (Derek Bok) === On Mon, 2004-09-20 at 20:42, susan lam wrote: > 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? -- //www.freelists.org/webpage/oracle-l