Re: Table monitoring

From: Ms. D.H. Harvey <qq45_at_liverpool.ac.uk>
Date: 25 Mar 2003 15:38:13 GMT
Message-ID: <b5pt55$6v5$1@news.liv.ac.uk>

,shortone <david.leather_at_sssltd.co.uk> wrote:
: I have a dataload which has several phases, I would like to use the
: 'staleness' of the stats to initiate an anlayze between phases,
: however given that SMON only updates the mon_mods$ every 3 hours, is
: there an event to force an update or an x$ table , etc to get at the
: info sooner?

: Thanks in advance

If you're using 9i look at dbms_stats.flush_database_monitoring_info

HTH Helen Received on Tue Mar 25 2003 - 09:38:13 CST