Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Table monitoring
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 ?
"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
Received on Wed Mar 26 2003 - 03:34:31 CST