Re: table monitoring ( dbms_stats )

Kevin Brand wrote:
>
> Anybody have a slick trick that will cause SMON to write the estimated table
> modifications into the appropriate view?
>
> 8.1.7.0.0 EE/ AIX
>
> Thanks,
>
> -Kevin
> --
>
> Remove the x from address for email

You probably want to upgrade to 9i where there is a routine within dbms_stats to do so :-)

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."