Re: Advice, archive redo log apply to slow
- From: "Yavor Ivanov" <Yavor_Ivanov@xxxxxxxx>
- To: george@xxxxxxxxxxxx, oracle-l@xxxxxxxxxxxxx
- Date: Thu, 07 Dec 2006 16:08:35 +0200
Hi, George
You forgot to say what version of Oracle is this.
Did you check what waits are occuring on DR? This might help...
--
Regards,
Yavor Ivanov
Senior Database Expert
Stemo Ltd
On Thu, 07 Dec 2006 15:00:46 +0200, George <george@xxxxxxxxxxxx> wrote:
> Hi all.
>
> ok this is a difficult one.
>
> Production is a IBM p595 (Power 5) 32 cpu's
> DR is a IBM 690 (Power 4) 32 cpu's
>
> the hardware configuration is exactly the same other than for the 595 to 690.
>
> both machines has 32 hba's (2 GB/ports) connecting to exactly the same lun
> design, down to naming, number of spindles. spindle speeds etc, whats
> located on the spindles, kernel parameters.
>
> at the moment production can product 4000 archive redo log files per day,
> DR can only apply 3000.
>
> wierd thing is DR IO layers are all idling, this is the view from the
> spindle performance, HBA's everything is idling, cpu's max usage is like
> 25%.
>
> hwo can i dig deeper, how can i get DR to apply log files faster.
>
> oh each log file is 250mb.
>
> DR while applying log files say via nmon it is reading 10mb/sec. we have
> shown we can do 10 times that easily.
>
> thanks.
>
>
> ------------------------------------------------
> George
>
> george@xxxxxxxxxxxx
>
> You Have The Obligation to Inform One Honestly of the risk, And As a Person
> You Are Committed to Educate Yourself to the Total Risk In Any Activity!
> Once Informed & Totally Aware of the Risk,
> Every Fool Has the Right to Kill or Injure Themselves as They See Fit!
>
>
>
> -------------------------------------------
> For super low premiums, click here http://www.webmail.co.za/dd.pwm
>
> --
> //www.freelists.org/webpage/oracle-l
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
