It's not correct, check metalink -- there is a note about that.
--
Vladimir Begun
The statements and opinions expressed here are my own and
do not necessarily represent those of Oracle Corporation.
K Gopalakrishnan wrote:
> Kirti:
>
> I think the interval is changed to 5 minutes from
> 3 hours starting from 9i (rel2?).
>
> Best Regards,
> K Gopalakrishnan
>
> -----Original Message-----
> Kirti
> Sent: Wednesday, January 29, 2003 8:19 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Lisa,
> Monitoring, by itself, does not fire any automatic analyze. It simply
> montiors the DML activity on the monitored table and counts
> inserts/deletes/upates. Those counts may not be 100% accurate, but are very
> close. These can be viewed in dba_tab_modifications, and are dumped there by
> SMON every 3 hours or so (in 9i there is a new procedure,
> flush_database_monitoring_info, to flush these counts to this view on
> demand). These counts do not affect the ones maintained in *_tables views.
>
> Monitoring is basically there to help identify which tables may need
> statistics computed again. 'Gather stale' option will only analyze tables
> that have undergone DML activity (inserts/deletes/updates) that amounts to
> more than 10% of the number of rows (from previous analyze) in the table.
> And 'gather auto' option 'figures' out what tables to analyze, but you must
> execute dbms_stats. So, there is nothing automatic in gathering table stats.
>
> You can test it yourself..... remember there is a last_analyzed column ;)
>
> HTH,
>
> - Kirti
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Vladimir Begun
INET: vladimir.begun_at_oracle.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Thu Jan 30 2003 - 01:23:54 CST
