Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Advice, archive redo log apply to slow

Re: Advice, archive redo log apply to slow

From: Yavor Ivanov <Yavor_Ivanov_at_stemo.bg>
Date: Thu, 07 Dec 2006 16:08:35 +0200
Message-ID: <op.tj6z8lvhtjan04@y-ivanov.sf.stemo.bg>

	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_at_mighty.co.za> 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_at_mighty.co.za
>
> 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
>
> --
> http://www.freelists.org/webpage/oracle-l
>
-- http://www.freelists.org/webpage/oracle-l
Received on Thu Dec 07 2006 - 08:08:35 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US