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

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

Advice, archive redo log apply to slow

From: George <george_at_mighty.co.za>
Date: Thu, 7 Dec 2006 15:00:46 +0200 (SAST)
Message-ID: <2632.196.13.231.16.1165496446.squirrel@mail.mighty.co.za>


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 Received on Thu Dec 07 2006 - 07:00:46 CST

Original text of this message

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