ltiple 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
>
y, July 08, 2002 10:54 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 a
Title: RE: When was analyze run last?
Ron,
Others have mentions the LAST_ANALYZED column of DBA_INDEXES or DBA_TABLES. Sorry but no such columns in 7.3.4.
You could look at the LAST_ANALYZED column of DBA_TAB_COLUMNS. It will tell you when the table was last analyzed and you might
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,
ch
Nope, not in 7.3.4. Look in DBA_TAB_COLUMNS. It should have a last_analyzed column
but I am not sure if this is specifically for the indexes last analyzed date.
Dave
-Original Message-
Sent: Monday, July 08, 2002 12:18 PM
To: Multiple recipients of list ORACLE-L
Hi Smith,
check LAS
Looks into last_analysed column of user_indexes .
-Bp
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, July 08, 2002 9:33 AM
> If there a way in 7.3.4 to tell the last time analyze was run on an index?
>
> Ron Smith
> --
> Please see the
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:[EMAIL PROTECTED]]
> Sent: 08 July 2002 17:33
> To: Multiple recipients of list ORACLE-L
> Subject: When w
