RE: I/O waits hurting anyone?
From: Mark W. Farnham <mwf_at_rsiz.com>
Date: Tue, 18 Feb 2014 12:31:18 -0500
Message-ID: <027501cf2ccf$3c2a47d0$b47ed770$_at_rsiz.com>
That depends largely on two factors:
Date: Tue, 18 Feb 2014 12:31:18 -0500
Message-ID: <027501cf2ccf$3c2a47d0$b47ed770$_at_rsiz.com>
That depends largely on two factors:
- How much of your i/o "wait" is actually cpu/data movement, burning cpu.
- Whether your i/o is obstructing some other job's need for data access
mwf
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
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
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Feb 18 2014 - 18:31:18 CET