Re: cpu time Statistics at cursor level: underlying v$ or x$ tables ????

Jonathan Lewis wrote:
>
> This appears in v$sql in Oracle 9, but the
> overhead should be considered - apparently
> there are platforms (such as hpux) where the
> cost of enabling timed_statistics is now much
> more significant.
>
> --
> Jonathan Lewis
> http://www.jlcomp.demon.co.uk
>
> Host to The Co-Operative Oracle Users' FAQ
> http://www.jlcomp.demon.co.uk/faq/ind_faq.html
>
> Author of:
> Practical Oracle 8i: Building Efficient Databases
>
> Screen saver or Life saver: http://www.ud.com
> Use spare CPU to assist in cancer research.
>
> Pascal Gineste wrote in message ...
> >Hello Guru,
> >
> >I'm a beginner with oracle; and i've already searched on the web
> >(without any success) if it is possible to have cpu time on individual
> >SQL statements:
> >
> > 1) without SQL_Trace / tk_prof (too much overhead)
> > 2) with TIMED_STATISTICS = true in init.ora
> >
> >I know that it is possible to get it from sesstat on a per session
> >basis
> >(statistics# = 12 (CPU used by this session); but i want to know
> >if it is possible to have this cpu time in the same precise
> >way as SQLtrace does (by sql statement);
> >but by directly querying the v$ or x$ view ?
> >
> >Can you help me ?

There is the well-publicised bugs in 8.1.5,6 and even a little in 7 - but is there something in 9 thats popped up?

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."