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 ?
Received on Mon Sep 17 2001 - 08:43:10 CDT
