Ooops! RE: Statistics timestamp & 'under-the-hood' column names

--openmail-part-090bf1f0-00000001

Content-Type: text/plain; charset=US-ASCII; name="BDY.TXT"
Content-Disposition: inline; filename="BDY.TXT"
Content-Transfer-Encoding: 7bit

Ooops! forgot about DBA_TAB_COLUMNS.LAST_ANALYZED!!!

Thanks anyway
John

> -----Original Message-----
> From: John J. Kanagaraj
> Sent: Wednesday, 03 May, 2000 9:09 AM
> To: 'oracledba_at_quickdoc.co.uk'; 'oracle-l_at_fatcity.com'
> 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 **
>
>
>

--openmail-part-090bf1f0-00000001

Content-Type: application/ms-tnef; name="WINMAIL.DAT"
Content-Disposition: attachment; filename="WINMAIL.DAT"
Content-Transfer-Encoding: base64

eJ8+IscmAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAAAElQTS5N aWNyb3NvZnQgTWFpbC5Ob3RlADEIAQ2ABAACAAAAAgACAAEDkAYADAAAAAEAAAADABcAAQAA ABwAAQOQBgAMAAAAAQAAAAMANgAAAAAAOgABBIABAEAAAABPb29wcyEgUkU6IFN0YXRpc3Rp Y3MgdGltZXN0YW1wICYgJ3VuZGVyLXRoZS1ob29kJyBjb2x1bW4gbmFtZXMAWhYBA5AGAAwA AAABAAAACwACAAEAAAAPAAEDkAYADAAAAAEAAAALACsAAAAAADcAAQOQBgAMAAAAAQAAAAMA LgAAAAAAMgABA5AGABQAAAABAAAAAgExAAEAAAABAAAAAAAAADcAAQOQBgAQAAAAAQAAAEAA OQAAZnCiorS/AQgEAQOQBgAkAAAAAQAAAB4AQgABAAAAEgAAAEpvaG4gSi4gS2FuYWdhcmFq AAAAOwYBA5AGABAAAAABAAAAQABIAMAgHaOitL8BPwQBA5AGAEgAAAABAAAAHgBwAAEAAAA1 AAAAU3RhdGlzdGljcyB0aW1lc3RhbXAgJiAndW5kZXItdGhlLWhvb2QnIGNvbHVtbiBuYW1l cwAAAADdEwEDkAYALAAAAAEAAAACAXEAAQAAABsAAAABv7ScOH0rpM/OIIER1JM2AGCXmRGz AAGC2gAAwgsBA5AGAAwAAAABAAAAAwAGEDtzrhWLAQEDkAYADAAAAAEAAAADAAcQhAMAAKIA AQOQBgB4AAAAAQAAAB4ACBABAAAAZQAAAE9PT1BTRk9SR09UQUJPVVREQkFUQUJDT0xVTU5T TEFTVEFOQUxZWkVEVEhBTktTQU5ZV0FZSk9ITi0tLS0tT1JJR0lOQUxNRVNTQUdFLS0tLS1G Uk9NOkpPSE5KS0FOQUdBUkEAAAAAzhwBA5AGAAwAAAABAAAAAwAQEAAAAAAkAAEDkAYADAAA AAEAAAADABEQAwAAACgAAQOQBgAUAAAAAQAAAB4AQhABAAAAAQAAAAAAAABzAAEDkAYAEAAA AAEAAABAAAcwYDblQ6K0vwFMBAEDkAYAEAAAAAEAAABAAAgwYDblQ6K0vwFNBAEDkAYAIAAA AAEAAAACAQswAQAAABAAAADmz6QrgSDUEZM2AGCXmRGzdwcBA5AGAAwAAAABAAAAAwDeP69v AAA/AgEDkAYAJAAAAAEAAAADAEilCCAGAAAAAADAAAAAAAAARgAAAAAQhQAAAAAAALoCAQOQ BgAkAAAAAQAAAAMASaUIIAYAAAAAAMAAAAAAAABGAAAAAAGFAAAAAAAArAIBA5AGACQAAAAB AAAAAwBKpQggBgAAAAAAwAAAAAAAAEYAAAAAEYUAAAAAAAC9AgEDkAYAJAAAAAEAAAADAEul CCAGAAAAAADAAAAAAAAARgAAAABShQAA4xUAAPcDAQOQBgAsAAAAAQAAAB4ATKUIIAYAAAAA AMAAAAAAAABGAAAAAFSFAAABAAAABAAAADguNQC9AwEDkAYAJAAAAAEAAAALAE2lCCAGAAAA AADAAAAAAAAARgAAAAAGhQAAAAAAAL0CAQOQBgAkAAAAAQAAAAsATqUIIAYAAAAAAMAAAAAA AABGAAAAAA6FAAAAAAAAxgIBA5AGACQAAAABAAAAAwBPpQggBgAAAAAAwAAAAAAAAEYAAAAA GIUAAAAAAADJAgEDkAYALAAAAAEAAAAeAFClCCAGAAAAAADAAAAAAAAARgAAAAA2hQAAAQAA AAEAAAAAAAAABQMBA5AGACwAAAABAAAAHgBRpQggBgAAAAAAwAAAAAAAAEYAAAAAN4UAAAEA AAABAAAAAAAAAAcDAQOQBgAsAAAAAQAAAB4AUqUIIAYAAAAAAMAAAAAAAABGAAAAADiFAAAB AAAAAQAAAAAAAAAJAwEDkAYAJAAAAAEAAAALAFOlCyAGAAAAAADAAAAAAAAARgAAAAAAiAAA AAAAAMMCAQOQBgAkAAAAAQAAAAsAVKULIAYAAAAAAMAAAAAAAABGAAAAAAWIAAAAAAAAyQIB A5AGABQAAAABAAAAHgA9AAEAAAABAAAAAAAAAF4AAQOQBgAMAAAAAQAAAAMAgBD/////kAQB CQAEAAIAAAAAAAAAAQOQBgAMAAAAAQAAAAsAIwAAAAAALwABA5AGAAwAAAABAAAACwApAAAA AAA1AAEEkAYALAQAAAIAAAASAAAAAwAAMAMAAAALAA8OAAAAAAIB/w8BAAAATwAAAAAAAACB Kx+kvqMQGZ1uAN0BD1QCAAABAG9yYWNsZWRiYUBxdWlja2RvYy5jby51awBTTVRQAG9yYWNs ZWRiYUBxdWlja2RvYy5jby51awAAHgACMAEAAAAFAAAAU01UUAAAAAAeAAMwAQAAABkAAABv cmFjbGVkYmFAcXVpY2tkb2MuY28udWsAAAAAAwAVDAEAAAACAfkPAQAAAE8AAAAAAAAAgSsf pL6jEBmdbgDdAQ9UAgAAARBvcmFjbGVkYmFAcXVpY2tkb2MuY28udWsAU01UUABvcmFjbGVk YmFAcXVpY2tkb2MuY28udWsAAAMA/g8GAAAAHgABMAEAAAAbAAAAJ29yYWNsZWRiYUBxdWlj a2RvYy5jby51aycAAAIBCzABAAAAHgAAAFNNVFA6T1JBQ0xFREJBQFFVSUNLRE9DLkNPLlVL AAAAAwAAOQAAAAALAEA6AAAAAAMAcToAAAAAHgD2XwEAAAAZAAAAb3JhY2xlZGJhQHF1aWNr ZG9jLmNvLnVrAAAAAAIB918BAAAATwAAAAAAAACBKx+kvqMQGZ1uAN0BD1QCAAABAG9yYWNs ZWRiYUBxdWlja2RvYy5jby51awBTTVRQAG9yYWNsZWRiYUBxdWlja2RvYy5jby51awAAAwD9 XwEAAAADAP9fAAAAAAIB9g8BAAAABAAAAAAAAAMSAAAAAwAAMAQAAAALAA8OAAAAAAIB/w8B AAAARwAAAAAAAACBKx+kvqMQGZ1uAN0BD1QCAAABAG9yYWNsZS1sQGZhdGNpdHkuY29tAFNN VFAAb3JhY2xlLWxAZmF0Y2l0eS5jb20AAB4AAjABAAAABQAAAFNNVFAAAAAAHgADMAEAAAAV AAAAb3JhY2xlLWxAZmF0Y2l0eS5jb20AAAAAAwAVDAEAAAACAfkPAQAAAEcAAAAAAAAAgSsf pL6jEBmdbgDdAQ9UAgAAARBvcmFjbGUtbEBmYXRjaXR5LmNvbQBTTVRQAG9yYWNsZS1sQGZh dGNpdHkuY29tAAADAP4PBgAAAB4AATABAAAAFwAAACdvcmFjbGUtbEBmYXRjaXR5LmNvbScA AAIBCzABAAAAGgAAAFNNVFA6T1JBQ0xFLUxARkFUQ0lUWS5DT00AAAADAAA5AAAAAAsAQDoA AAAAAwBxOgAAAAAeAPZfAQAAABUAAABvcmFjbGUtbEBmYXRjaXR5LmNvbQAAAAACAfdfAQAA AEcAAAAAAAAAgSsfpL6jEBmdbgDdAQ9UAgAAAQBvcmFjbGUtbEBmYXRjaXR5LmNvbQBTTVRQ AG9yYWNsZS1sQGZhdGNpdHkuY29tAAADAP1fAQAAAAMA/18AAAAAAgH2DwEAAAAEAAAAAAAA Received on Tue May 02 2000 - 20:55:20 CDT