Standby Database performance

From: kapil vaish <kapilvaish1_at_yahoo.com>
Date: Tue, 22 Nov 2011 11:23:34 -0800 (PST)
Message-ID: <1321989814.50621.YahooMailNeo_at_web111702.mail.gq1.yahoo.com>


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 ..

thanks
kapil Vaish

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Nov 22 2011 - 13:23:34 CST

Original text of this message