Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: What system table shows when a table was last analyzed?
Thanks :-)
"ImPrecise" <f_puhan_at_precise.com> wrote in message
news:f_puhan-51C9B0.10512811072002_at_vienna7.his.com...
> In article <FngX8.43$ab1.2095_at_news2.calgary.shaw.ca>,
> "Brian Peasey" <bpeasey_at_doncarsys.com> wrote:
>
> > Oracle8iEnt (8.17) Win2000
> >
> > Hi,
> >
> > In DBA Studio I can see when a table was last analyzed. Can someone tell
me
> > what table and column this info is located?
> >
> > Best Regards,
> > Brian Peasey
> >
> >
>
> Try DBA_TABLES. There is a column LAST_ANALYZED of type DATE.
>
> --
> The underscore character does not belong in my address. You know the
drill...
> ***
> Anyone sufficiently smart enough to configure and use USEnet for research
should
> be smart enough to Read The Freakin' Documentation!
Received on Thu Jul 11 2002 - 10:50:54 CDT