Re: TIMED_STATISTICS

On Mar 27, 7:16 pm, hpuxrac <johnbhur..._at_sbcglobal.net> wrote:
> On Mar 27, 7:12 pm, "Pete's" <empete2..._at_yahoo.com> wrote:
>
> snip
>
> > > 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
>
> Yes like I said before "on all my databases".
>
> This was a popular type of question on oracle version 7 ... but
> now ... it's ancient history.

Just wanted to check, I too thought it was ancient too. I see that there were bugs regarding it in version 8 & 8i, but that's resolved and moot. Also researching docs in 10g on the parameter(I may be reading more into than I should but), even if you turn it off, Oracle may disregard the setting and turn it on anyway.

Thanks,
Pete's Received on Fri Mar 28 2008 - 07:55:43 CDT