Re: tkprof question

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Wed, 27 Nov 2002 22:02:24 +1000
Message-ID: <xo1F9.84819$g9.239538@newsfeeds.bigpond.com>

"Andy" <andy.spaven_at_eps-hq.co.uk> wrote in message news:qW%E9.2641$9R.10226819_at_newsr2.u-net.net...
> To get CPU timings you need the initialization parameter timed_statistics
> set to TRUE for either the whole db or just your session. This can be
done
> by
>
> 1) permanently in the init.ora file (see your dba) or
> 2) by issuing alter system set timed_statistics=true in a sql session (see
> your dba or risk his wrath altering system parameters).
> 3) by issuing alter session set timed_statistics=true in a sql session
(not
> that you're likely to be able to do this for a third party product unless
> you have the source and can rebuild it - yuk).
>
> 1 & 2 will have an impact on performance as Oracle gathers statistics for
> all sessions but only a small one (2-3% tops).
>

Hi Andy,

I yet to see timed_statistics have any discernable impact on performance. Do you have any particular environment or configuration where you've measured anything as significant as 2-3% ?

Cheers

Richard Received on Wed Nov 27 2002 - 06:02:24 CST