Re: Table monitoring

From: Ms. D.H. Harvey <qq45_at_liverpool.ac.uk>
Date: 26 Mar 2003 15:05:38 GMT
Message-ID: <b5sfk2$1ve$1@news.liv.ac.uk>

,shortone <david.leather_at_sssltd.co.uk> wrote: : Thanks Helen, a 9i feature I was unaware of. But alas it is if no help : cause I am using 8.1.7.3. Any other suggestions ?

Sorry I don't know of, don't think there is, any way to do this pre 9i.

: "Ms. D.H. Harvey" <qq45_at_liverpool.ac.uk> wrote in message news:<b5pt55$6v5$1_at_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

Helen Received on Wed Mar 26 2003 - 09:05:38 CST