In article <95bml0$g0j$1_at_nnrp1.deja.com>,
dmnwork_at_my-deja.com wrote:
>
>
> An Oracle DB monitoring product I'm using (Spotlight on Oracle) wants
> to set timed_statistics=TRUE. The product docs claim this won't create
> significant DB overhead (this is for an ORCL 8.0.5 database, which
will
> be upgraded to 8.1.6 eventually).
>
> What's the real answer? I know ANALYZE TABLE COMPUTE STATISTICS
> statements can be a real drag on performance. What will happen if
> timed_statistics is turned on?
>
> Thanks very much.
>
> - Dana
>
Setting the init.ora parameter for timed statistics to true has had no
noticable effect on any of our systems. Whatever effect it is having
is unimportant compared to the value of the statistics in tuning so if
you have a tuning problem do not hesitate to use them. If you do not
have a tuning problem, I would still try running with statistics on.
--
Mark D. Powell -- The only advice that counts is the advice that
you follow so follow your own advice --
Sent via Deja.com
http://www.deja.com/
Received on Thu Feb 01 2001 - 07:47:07 CST
