I thought you could just query the last_analyzed column in dba_tables?
> -----Original Message-----
> From: john.j.kanagaraj_at_shell.com.bn [SMTP:john.j.kanagaraj_at_shell.com.bn]
> Sent: Tuesday, May 02, 2000 9:25 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Statistics timestamp & 'under-the-hood' column names
>
> 'gals' || 'guys',
>
> Am I right in assuming that the SYS.HIST_HEAD$ (column TIMESTAMP in
> V7.3.4 and column TIMESTAMP# in 8.0.x and 8.1.x) is the _only_ place
> where I can find out when the statistics for a particular table was
> last generated? (among other nuggets of information :)
>
> Just digging thru SQL.BSQ of the 8.x versions and note that a number of
> equivalent columns have a '#' appended to them - causes a lot of grief
> on porting home grown managament scripts and utilities that look for
> some additional details 'under the hood'...... (e.g.
> HIST_HEAD$.TIMESTAMP, OBJ$.TYPE and USER$.TYPE)
>
> TIA,
> John Kanagaraj
> Brunei Shell Petroleum
> http://www.geocities.com/john_sharmila
>
> God so loved the world that He didn't send a committee! (See John 3:16
> for details)
> ** Opinions expressed here are solely mine and not necessarily those of
> my employer **
>
> << File: WINMAIL.DAT >>
Received on Wed May 03 2000 - 14:31:45 CDT
