Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: table monitoring ( dbms_stats )
Thanks, but it's not an option. Guess my testing is just going to take a while!
-Kevin
"Connor McDonald" <connor_mcdonald_at_yahoo.com> wrote in message
news:3D3F1B1D.1E7B_at_yahoo.com...
> 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..."
Received on Thu Jul 25 2002 - 07:26:43 CDT