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?
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 - 09:51:28 CDT
![]() |
![]() |