RE: is dispatcher cpu caculated in "CPU used by this session"?

Hi,

Use v$sess_time_model for getting CPU usage, this is updated every 5 seconds regardless whether you're in call or not.

For background processes there are stats called "background cpu time" and "background elapsed time" for example...

Cheers,
Tanel.
http://blog.tanelpoder.com

> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Zhu,Chao
> Sent: Tuesday, August 21, 2007 15:35
> To: LS Cheng
> Cc: oracle-l
> Subject: Re: is dispatcher cpu caculated in "CPU used by this
> session"?
>
> I am nto sure either, can't find any information about it.
> But interesting that background process (like lgwr/dbwr) cpu
> usage, are not caculated inside (CPU used by this session).
>
> And , dispatcher process does not have a SID/serial# in
> v$process/session;

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