Re: question on standby (LGWR, ASYNC)

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? 




--
http://www.freelists.org/webpage/oracle-l

Other related posts: