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

From: Tanel Poder <tanel.poder.003_at_mail.ee>
Date: Thu, 04 Oct 2007 00:38:35 +0800
Message-id: <028c01c805db$d9300a00$6701a8c0@windows01>

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_at_freelists.org 

> [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Alberto Dell'Era

> Sent: Wednesday, October 03, 2007 17:30

> To: qihua wu

> Cc: oradbt054_at_gmail.com; 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

Received on Wed Oct 03 2007 - 11:38:35 CDT