Re: Advice, archive redo log apply to slow

        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
>
> --
> http://www.freelists.org/webpage/oracle-l
>
--
http://www.freelists.org/webpage/oracle-l


Other related posts: