RE: I/O waits hurting anyone?

From: Mark W. Farnham <>
Date: Tue, 18 Feb 2014 12:31:18 -0500
Message-ID: <027501cf2ccf$3c2a47d0$b47ed770$>

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


From: [] 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!  


Received on Tue Feb 18 2014 - 18:31:18 CET

Original text of this message