Re: Does table monitoring handle all statistics for you?

On Mon, 25 Jun 2001 20:16:50 +0100, "Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote:

>
>Monitoring keeps an approximate count
>of inserts, updates and deletes. Every
>three hours, SMON write the in-memory
>counts to a table (with a name like mon_mod$)
>
>You still need to sort out statistics from time
>to time,

Why is that? What will fall out of order?

> but the dbms_stats analyze procedures
>now have the option to 'analyze only stale objects';

Which makes it run a lot faster. That is nice.

>Oracle then uses the values in mon_mod$ to
>decide if the existing stats qualify as stale.
>

If is stale, then it hasn't been written. If it hasn't been written, then there was nothing to update. If there was nothing to update who cares if it is stale? Am I missing something?

Brian Received on Mon Jun 25 2001 - 15:20:51 CDT