RE: Standby Database performance
Date: Wed, 23 Nov 2011 18:22:54 -0500
Important information left out :
What version of Orac le?
What kind of hardware?
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of kapil vaish Sent: Tuesday, November 22, 2011 2:24 PM To: oracle-l_at_freelists.org
Subject: Standby Database performance
Hi Guys ,
we have physical standby database for one of our biggest database. Scripts ship the archived log to standby server and then using parallel 32, manual recovery is performed (thru scripts) . Archived log size is 2 GB and daily production archive generation is aorund 2.5 TB. We are trying to increase performance on our standby database. We tried tuning various standby related parameters and IO, maximum apply rate we could achieve is 45 sec per archive log. Can you suggest any other tunings you may have seen in your environments ? any pointers are appreciated ..
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Nov 23 2011 - 17:22:54 CST
>>> This e-mail and any attachments are confidential, may contain legal, professional or other privileged information, and are intended solely for the addressee. If you are not the intended recipient, do not use the information in this e-mail in any way, delete this e-mail and notify the sender. CEG-IP1