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

Home -> Community -> Usenet -> c.d.o.server -> Oracle IO tuning tips/practices on Windows

Oracle IO tuning tips/practices on Windows

From: NetComrade <netcomradeNSPAM_at_bookexchange.net>
Date: Wed, 01 Feb 2006 18:18:14 -0500
Message-ID: <qjf2u1totvqj4q2l6v6tv9bcjojh9bvu0g@4ax.com>


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

Original text of this message

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