Subject: RE: what 's the difference between "CPU I/O Wait " and "db scatter/sqenecail w 2007-10-03 - By Tanel Poder
Back
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@(protected)
> [mailto:oracle-l-bounce@(protected)] On Behalf Of Alberto Dell'Era
> Sent: Wednesday, October 03, 2007 17:30
> To: qihua wu
> Cc: oradbt054@(protected); 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
|
|
