Oracle told me (via tar) that oracle does not store the data anywhere...
so it does not caculate the cost of dispatcher...
sad news.
On 8/20/07, Tanel Poder <tanel.poder.003_at_mail.ee> wrote:
> 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..
>
--
Regards
Zhu Chao
www.cnoug.org
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Aug 23 2007 - 08:20:55 CDT
