RE: I/O waits hurting anyone?
- From: "Mark W. Farnham" <mwf@xxxxxxxx>
- To: <vxsmimmcp@xxxxxxxxxx>, "'ORACLE-L'" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 18 Feb 2014 12:31:18 -0500
That depends largely on two factors:
1) How much of your i/o "wait" is actually cpu/data movement, burning
cpu.
2) Whether your i/o is obstructing some other job's need for data access
mwf
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of McPeak, Matt
Sent: Tuesday, February 18, 2014 12:24 PM
To: ORACLE-L
Subject: I/O waits hurting anyone?
I have a process that executes a lot. Over 6 days it's executed 1.3 million
times. The elapsed time per call averages 0.8 seconds, and the I/O wait
time per call averages 0.7 seconds.
In other words, it spends most of its time waiting.
I'll look into all that. my question is more general: am I right in saying
that the I/O waits don't load the system in any way and don't hurt any
processes besides the one that is waiting?
Thanks in advance!
Matt
Other related posts:
