From: hpuxrac <>
Date: Wed, 26 Mar 2008 14:19:58 -0700 (PDT)
Message-ID: <>

On Mar 26, 3:09 pm, "Pete's" <> 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. Received on Wed Mar 26 2008 - 16:19:58 CDT

Original text of this message