Re: question on standby (LGWR, ASYNC)
- From: Carel-Jan Engel <cjpengel.dbalert@xxxxxxxxx>
- To: susanzlam@xxxxxxxxx
- Date: Mon, 20 Sep 2004 21:44:30 +0200
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
Other related posts:
