Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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