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

Hi,

Btw, the scheduling latency problem is where where timed_os_statistics comes
in handy - it will populate the "OS Wait-cpu (latency) time" statistic in
v$sesstat and v$sysstat, so you can actually measure how long time was
wasted on waiting in CPU runqueues.

There's also an OS_CPU_WAIT_TIME statistic in V$OSSTAT (10g+) which gives
you pretty much the same info.

--
Regards,
Tanel Poder
http://blog.tanelpoder.com
 
> -----Original Message-----
> From: oracle-l-bounce@xxxxxxxxxxxxx 
> [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Alberto Dell'Era
> Sent: Wednesday, October 03, 2007 17:30
> To: qihua wu
> Cc: oradbt054@xxxxxxxxx; oracle-l
> Subject: Re: what's the difference between "CPU I/O Wait" and 
> "db scatter/sqenecail wait"
> 
> It's not "misleading" as far as you know how it works; "db 
> file sequential/scattered read" wait time is the time elapsed 
> from the instant Oracle noticed the buffer was not in the 
> buffer cache, and the instant it could resume processing 

--
http://www.freelists.org/webpage/oracle-l

Other related posts: