Re: TIMED_STATISTICS

On Mar 26, 4:19 pm, hpuxrac <johnbhur..._at_sbcglobal.net> wrote:
> On Mar 26, 3:09 pm, "Pete's" <empete2..._at_yahoo.com> wrote:
>
>
>
> > Hey all:
>
> > Servers -- solaris/aix any OS
> > DB -- 9.2. & 10.2
>
> > What are others doing in setting "timed_statistics"? TRUE? FALSE?
>
> > Obviously it's dynamic, but, if you turn it off and you have to do
> > some reactive tuning, you lose your statistics on your wait events
> > before ever turning it back on. If you were doing some sql tracing,
> > you would want it on.
>
> > I've seen some say you should only turn it on when you absolutely need
> > it. I've also seen it where you just turn it on and don't worry about
> > it. If I recall back in the 7.3.4 days, it was recommended to be
> > turned off. Maybe someone with Oracle can weigh in on how expensive
> > timed_statistics is to a database?
>
> > TIA,
> > Pete's
>
> Just like Mark Powell it's been set to true on all my databases since
> version 7. No significant overhead.

Would you leave timed_stats on for a production database?

TIA
Pete's Received on Thu Mar 27 2008 - 18:12:57 CDT