Re: setting timed_statistics = true

Hi

My experience ...
timed_statistics=true takes approx. 10% of the performance.

time_statistics is a dynamic init.ora parameter (since 8i) and you can change this parameter "on the fly" for the database.

I don't know, if you change time_statistics on session level, you gather all time statistics that could be needed for a performance analysis.

Kind regards
Hernan

"Cookie Monster" <cookie.monster_at_somewhere.com> schrieb im Newsbeitrag news:c1v38r$1n78pt$1_at_ID-82797.news.uni-berlin.de...
> Hi,
>
> Packages like perfstats require timed_statistics to be set to true for
> calculating wait times. I'm think of setting this value to true at the
> instance level. But does it make sense to have this value set true all
the
> time? Does this have an impact on performance?? Should I only use this
at
> the session level when required?
>
> Thanks for any info,
> Cookie.
>
>
Received on Mon Mar 01 2004 - 08:43:02 CST