I/O waits hurting anyone?
From: McPeak, Matt <vxsmimmcp_at_subaru.com>
Date: Tue, 18 Feb 2014 17:24:17 +0000
Message-ID: <D7864FA3E7830B428CB2A5A5301B63EE7D2A3962_at_S7041VA005.soa.soaad.com>
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.
Date: Tue, 18 Feb 2014 17:24:17 +0000
Message-ID: <D7864FA3E7830B428CB2A5A5301B63EE7D2A3962_at_S7041VA005.soa.soaad.com>
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
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Feb 18 2014 - 18:24:17 CET