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

Home -> Community -> Mailing Lists -> Oracle-L -> what's the difference between "CPU I/O Wait" and "db scatter/sqenecail wait"

what's the difference between "CPU I/O Wait" and "db scatter/sqenecail wait"

From: qihua wu <staywithpin_at_gmail.com>
Date: Sat, 29 Sep 2007 14:19:48 -0700
Message-ID: <2689c1070709291419u7ce123ban721e2b20820a7945@mail.gmail.com>


In the EM, we can view the CPU usage at the server(OS) level that the CPU I/O wait is very high.
And from the database level, statspack will tell use the time about IO, such as scatter read or sequential read. Is the time spent on scatter/sequential read in the eye of oracle is the same or at least related to the "CPU I/O wait' at the unix level?

--
http://www.freelists.org/webpage/oracle-l
Received on Sat Sep 29 2007 - 16:19:48 CDT

Original text of this message

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