Re: setting timed_statistics = true

From: Mark <simmons_mark_at_yahoo.com>
Date: 5 Mar 2004 16:21:34 -0800
Message-ID: <5366fb41.0403051621.4acf5e40@posting.google.com>

I agree. I always set it, and it only seems to take less than 1%.

Mark Simmons
Sr. Oracle DBA
Sabre-Holdings, Southlake, TX

Brian Peasland <dba_at_remove_spam.peasland.com> wrote in message news:<404364E1.BB27F33E_at_remove_spam.peasland.com>...
> > My experience ...
> > timed_statistics=true takes approx. 10% of the performance.
>
> 10%?!?!? That seems pretty high.... I'd say less than 1% in my
> experience. As part of the "standards" I have for my databases, I set
> TIMED_STATISTICS=TRUE in all instances! And I haven't seen any noticable
> affects.
>
> HTH,
> Brian
>
>
> --
> ===================================================================
>
> Brian Peasland
> dba_at_remove_spam.peasland.com
>
> Remove the "remove_spam." from the email address to email me.
>
>
> "I can give it to you cheap, quick, and good. Now pick two out of
> the three"
Received on Fri Mar 05 2004 - 18:21:34 CST