| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: standby config --> FAL_SERVER / FAL_CLIENT
Hi Prem,
Yes there is a performance overhead with maximize protection. As I said = earlier, the LGWR process is going to ship the log changes to the = standby database (does not wait till its applied) and hence It boils = down to the network connectivity that exists between the primary and the = standby database. Your overhead is proportional to the network = bandwidth. Pls test it with a real load before you put in production.
Best Regards
Sriram Kumar
-----Original Message-----
From: Prem Khanna J [mailto:jprem_at_kssnet.co.jp]=20
Sent: Tuesday, February 10, 2004 4:01 PM
To: oracle-l_at_freelists.org
Subject: RE: standby config --> FAL_SERVER / FAL_CLIENT
>>Sri:Well the moment you say its maximize protection(Zero data=20
>>loss), The LGWR takes charge of ensuring that the Logfiles and the=20
>>remote standby redolog files are in sync. The transaction would be
signaled=20
>>a commit iff the transaction is applied to log file and the standby=20
>>redolog file. So don't worry abt placing your log files in a Shared
storage=20
>>you wont need them for this protection mode
Thanks again Sriram .=20
Read in docs that " Maximum Protection " has some performance overhead .
what's ur opinion about it ? anyway , i need to test it and see whether
it
is acceptable for me .
Regards,
Prem.
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- DISCLAIMER: This message contains privileged and confidential information and is = intended only for the individual named.If you are not the intended = recipient you should not disseminate,distribute,store,print, copy or = deliver this message.Please notify the sender immediately by e-mail if = you have received this e-mail by mistake and delete this e-mail from = your system.E-mail transmission cannot be guaranteed to be secure or = error-free as information could be = intercepted,corrupted,lost,destroyed,arrive late or incomplete or = contain viruses.The sender therefore does not accept liability for any = errors or omissions in the contents of this message which arise as a = result of e-mail transmission. If verification is required please = request a hard-copy version. ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Tue Feb 10 2004 - 06:15:28 CST
 |
 |