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

I haven't worked with shared servers for a while, but I guess the CPU used by dispatcher itself is reported in dispatchers v$sesstat entries..

If you want to do high-precision timing on 10g, query v$sess_time_model instead. Again, I don't know how it works with shared servers.

Btw, I just posted a new script for easy taking of session-level snapshots on my blog, you may find it useful..

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: Sunday, August 19, 2007 22:50
> To: oracle-l
> Subject: is dispatcher cpu caculated in "CPU used by this session"?
>
> hi, all,
> does anyone know whether statistics "cpu used by this
> session" also include the cpu used by dispatcher in shared
> server mode?
>
> --
> Regards
> Zhu Chao
> www.cnoug.org
> --
> http://www.freelists.org/webpage/oracle-l
>
>

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