Re: Does table monitoring handle all statistics for you?

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, but the dbms_stats analyze procedures now have the option to 'analyze only stale objects'; Oracle then uses the values in mon_mod$ to decide if the existing stats qualify as stale.

--
Jonathan Lewis

Host to The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Author of:
Practical Oracle 8i: Building Efficient Databases
See http://www.jlcomp.demon.co.uk/book_rev.html

Seminars on getting the best out of Oracle
See http://www.jlcomp.demon.co.uk/seminar.html






Brian Tkatch wrote in message <3b3750d8.236530390_at_news.alt.net>...


>I'd like to enable statistics, though I am not sure how often to

>gather them, and whether to get COMPLETE or ESTIMATE. So, I am reading

>up on it.

>

>Here's a question (or two).

>

>Does table monitoring handle all statistics for you? If I choose

>MONITORING on all the tables, do I need to gather statistics on my own

>at any point?

>

>Brian

>

>