Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Oracle IO tuning tips/practices on Windows
Can anyone point to a useful resource on tuning IO for Oracle on
Windows?
I've never dealt with Oracle on Windows before, but someone asked to help them out with IO performance problems (they can get the dell powervault SCSI disk array to push data to about 80Megs/sec at the (same) time when Oracle is only pushing about 20M/sec)
I know #'s are not that easy to compare, but I don't know where else to look into besides db_multiblock_read_count.
E.g., one of their queries has the following stats:
call count cpu elapsed disk query current rows
---- ------ ----- ---------- ---------- ---------- ---- ----------
Parse 1 0.03 0.02 0 0 0 0 Execute 1 1.71 1.75 0 0 0 0 Fetch 13 6.35 150.80 13001 45741 0 300
---- ------ ----- ---------- ---------- ---------- ---- ----------
total 15 8.10 152.59 13001 45741 0 300 Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited -------------------------------- Waited ---------- ------------ db file scattered read 121 1.83 4.10 db file sequential read 11137 1.85 129.46 SQL*Net message to client 13 0.00 0.00 SQL*Net more data to client 36 0.00 0.00 SQL*Net message from client 13 0.00 0.03
seems ike it's spending too much time on IO.
Thanks for any tips/links in advance
.......
We run Oracle 9.2.0.6 on RH4 AMD
remove NSPAM to email
Received on Wed Feb 01 2006 - 17:18:14 CST