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

Home -> Community -> Mailing Lists -> Oracle-L -> Rman io done waits and the rate parameter

Rman io done waits and the rate parameter

From: Fuad Arshad <fuadar_at_yahoo.com>
Date: Mon, 20 Dec 2004 06:37:14 -0800 (PST)
Message-ID: <20041220143714.63754.qmail@web80510.mail.yahoo.com>


we are having very high iodone waits.
and i was wonderign if somone on a list has had to go thru the same issues  

thisis a snap from the statspack reports.

                                                                   Avg
                                                     Total Wait   wait    Waits
Event                               Waits   Timeouts   Time (s)   (ms)     /txn

---------------------------- ------------ ---------- ---------- ------ --------
io done 7,318,903 5,192,927 122,807 17 146.5 sbtwrite2 4,240,771 0 126,120 30 84.9 io done 7,318,903 5,192,927 122,807 17 146.5

currently we are on gen1 tape drive plannign to move to gen2's the backup of a 1 tbte database takes around 4 hours but the application timings go up by 20%  

i am also looking at ways people have had to use the rate or the readrate parameter to throttle down the amount of i/o and tune down rman.

--

http://www.freelists.org/webpage/oracle-l Received on Mon Dec 20 2004 - 08:35:39 CST

Original text of this message

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