RE: When was analyze run last?

it's in dba_tab_columns and user_tab_columns (not very covenient, but that's where it is....) Barb

> ----------
> From: Nicoll, Iain (Calanais)[SMTP:iain.nicoll_at_calanais.com]
> Reply To: ORACLE-L_at_fatcity.com
> Sent: Monday, July 08, 2002 11:53 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: When was analyze run last?
>
> Not there on 7.3.4.4. It seems that the only clue you get is in
> dba_tab_columns last_analyzed and that won't tell you specifically when an
> index was last analyzed.
>
> Iain Nicoll
>
> -----Original Message-----
> Sent: Monday, July 08, 2002 6:18 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Hi Smith,
>
> check LAST_ANALYZED column of DBA_INDEXES or DBA_TABLES....
>
> I believe it shouldb be there in ver. 7.3.
>
> HTH
>
> Arul.
>
> > -----Original Message-----
> > From: Smith, Ron L. [SMTP:rlsmith_at_kmg.com]
> > Sent: 08 July 2002 17:33
> > To: Multiple recipients of list ORACLE-L
> > Subject: When was analyze run last?
> >
> > If there a way in 7.3.4 to tell the last time analyze was run on an
> index?
> >
> > Ron Smith
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Smith, Ron L.
> > INET: rlsmith_at_kmg.com
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing Lists
> > --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
> INET: arul.kumar_at_bt.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Nicoll, Iain (Calanais)
> INET: iain.nicoll_at_calanais.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Baker, Barbara
  INET: bbaker_at_denvernewspaperagency.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).