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