Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Finding out when a table or index was last analysed

Re: Finding out when a table or index was last analysed

From: Terry Dykstra <dontreply_tdykstra_at_cfol.ab.ca>
Date: 2000/07/11
Message-ID: <P2Ia5.31087$FQ.3109767@news0.telusplanet.net>#1/1

805 has the info too.

--
Terry Dykstra
Canadian Forest Oil Ltd.

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message
news:963332706.168.0.pluto.d4ee154e_at_news.demon.nl...

> User_tables and user_indexes, provided you have 8i
> In 7.3.4 it is definitely not captured, I'm not sure about 8.0.
> Please always specify version and platform.
> Version differences are getting bigger and bigger, it is a bore to outline
> procedures for three different versions.
>
> Regards,
>
> Sybrand Bakker, Oracle DBA
>
>
> "Keith Jamieson" <jamiesonk_at_phoenix.ie> wrote in message
> news:8kffr5$pk3$1_at_kermit.esat.net...
> > Which table or view do I need to look in to find out when a table or
index
> > was last analysed.
> >
> > TIA
> >
> > Keith
> >
> >
>
>
Received on Tue Jul 11 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US