Re: setting timed_statistics = true

From: <sybrandb_at_yahoo.com>
Date: 1 Mar 2004 07:24:11 -0800
Message-ID: <a1d154f4.0403010724.f3e4fc7@posting.google.com>

"Cookie Monster" <cookie.monster_at_somewhere.com> wrote in message 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.

Yes
No, except for HP-UX
No

Sybrand Bakker
Senior Oracle DBA Received on Mon Mar 01 2004 - 09:24:11 CST