RE: Standby Database performance
- From: "Jorgensen, Finn" <Finn.Jorgensen@xxxxxxxxxxxxxxxxx>
- To: kapil vaish <kapilvaish1@xxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 23 Nov 2011 18:28:35 -0500
Did you play with the parallel_execution_message_size parameter? I've seen some
percentage of performance improvement when increasing that value.
Thanks,
Finn
From: kapil vaish [mailto:kapilvaish1@xxxxxxxxx]
Sent: Wednesday, November 23, 2011 6:26 PM
To: Jorgensen, Finn; oracle-l@xxxxxxxxxxxxx
Subject: Re: Standby Database performance
DR 10.2.0.5, HP-Itanium, Super-Dome, EMC SAN, No ASM
From: "Jorgensen, Finn"
<Finn.Jorgensen@xxxxxxxxxxxxxxxxx<mailto:Finn.Jorgensen@xxxxxxxxxxxxxxxxx>>
To: "kapilvaish1@xxxxxxxxx<mailto:kapilvaish1@xxxxxxxxx>"
<kapilvaish1@xxxxxxxxx<mailto:kapilvaish1@xxxxxxxxx>>;
"oracle-l@xxxxxxxxxxxxx<mailto:oracle-l@xxxxxxxxxxxxx>"
<oracle-l@xxxxxxxxxxxxx<mailto:oracle-l@xxxxxxxxxxxxx>>
Sent: Wednesday, November 23, 2011 3:22 PM
Subject: RE: Standby Database performance
Important information left out :
What version of Orac le?
What OS?
What kind of hardware?
Storage?
ASM?
Thanks,
Finn
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx<mailto:oracle-l-bounce@xxxxxxxxxxxxx>
[mailto:oracle-l-bounce@xxxxxxxxxxxxx<mailto:oracle-l-bounce@xxxxxxxxxxxxx>] On
Behalf Of kapil vaish
Sent: Tuesday, November 22, 2011 2:24 PM
To: oracle-l@xxxxxxxxxxxxx<mailto:oracle-l@xxxxxxxxxxxxx>
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 ..
thanks
kapil Vaish
--
//www.freelists.org/webpage/oracle-l
>>> 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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
