Re: timed_statistics anyone?

Hi:

I leave timed_statistics on and run bstat/estat from a scheduled job daily. Gives you info to build a usage and growth profile. I can spot very little performance degradation in 7.3 and 8.0.

Good luck

--
David C. Sisk
http://www.ipass.net/~davesisk/ORACLEonNT.htm

marc bowden wrote in message <36307338.261511663_at_news.demon.co.uk>...
>Hi All
>
>I would like to get an idea of the affect on performance of switching
>this on. Specifically, I what I want to know, is what is the change
>in system behaviour when ts wre switched on.
>
>If, eg, statis. are monitored once a second, with little usage of cpu
>or memory and some small amount of data is updated, then it would seem
>feasible to leave them on all them time on a production database.
>
>On the other hand, if sampling is every few milliseconds and tens of
>thousands of rows are written to some system table somewhere then I'd
>take turning them on as an occasional luxury! :-)
>
>The answer presumably lies somewhere in between these extremes - can
>anyone enlighten me please?
>
>A Bientot
>Marc
>
Received on Sun Oct 25 1998 - 20:44:28 CST