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

Home -> Community -> Mailing Lists -> Oracle-L -> When was an index last rebuilt?

When was an index last rebuilt?

From: John Hallas <john.hallas_at_mail.com>
Date: Tue, 2 Jan 2001 15:07:39 -0000
Message-Id: <10729.125518@fatcity.com>


This is a multi-part message in MIME format.

------=_NextPart_000_0000_01C074CD.C0B24480
Content-Type: text/plain;

        charset="Windows-1252"
Content-Transfer-Encoding: 7bit

Can anybody help me identify when an index was last built please

I can tell when an index was created or ddl changed from user_indexes but I cannot see any way of telling when the index was last built. Has anybody any thoughts on this please.

Thanks in advance

John

------=_NextPart_000_0000_01C074CD.C0B24480
Content-Type: application/ms-tnef;

        name="winmail.dat"
Content-Transfer-Encoding: base64
Content-Disposition: attachment;

        filename="winmail.dat"

eJ8+IikPAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAAAElQTS5NaWNy b3NvZnQgTWFpbC5Ob3RlADEIAQ2ABAACAAAAAgACAAEGgAMADgAAANEHAQACAA8ABgAAAAIA8gAB A5AGAGAFAAAlAAAACwACAAEAAAALACMAAAAAAAMAJgAAAAAACwApAAAAAAADADYAAAAAAB4AcAAB AAAAIAAAAFdoZW4gd2FzIGFuIGluZGV4IGxhc3QgcmVidWlsdD8AAgFxAAEAAAAWAAAAAcB0zY0y /igNA+C/EdSlPewXTvJTNwAAAgEdDAEAAAAaAAAAU01UUDpKT0hOLkhBTExBU0BNQUlMLkNPTQAA AAsAAQ4AAAAAQAAGDgA8HYTNdMABAgEKDgEAAAAYAAAAAAAAAAuCtU6rOr8Rln4Sra6l4urCgAAA CwAfDgEAAAACAQkQAQAAADgBAAA0AQAAqgEAAExaRnXhl/ZlAwAKAHJjcGcxMjUmMgD4C2BuZwHQ NTdPAfcCpAPjAgBjaArAc7BldDAgBxMCgH0KgZJ2CJB3awuAZDQMYM5jAFALAwu1IEMDkQBwAnkG 4GR5IGhlbORwIAeAIGkBAAIwBpA9FHB3FJAT8hUAEoBleC0VkGEEIAtgcwVAYnXXAxAFQAtQZRaQ ZQqiCoTRCoBJIGMDkXQUoAMglxWvGKAJcGEY8GQgBbF8ZGQDIBDhDyAasQNSIPJ1ESByXxYjB5EX EAVA+RiTbm8FQBEgFPAUERZxsRRwb2YgGOMLgGcZNI50FJAWHxciLiBIFpGPFBYeAh+QCGBnaHQE IK8CIB+BBAAXZS4X2lQbYU5rBCALgBQAZHYAcGPjF8sX1EpvaAOhF+MR4QIAJ5ALAACACCAGAAAA AADAAAAAAAAARgAAAAADhQAAAAAAAAMAAoAIIAYAAAAAAMAAAAAAAABGAAAAABCFAAAAAAAAAwAF gAggBgAAAAAAwAAAAAAAAEYAAAAAUoUAACdqAQAeACWACCAGAAAAAADAAAAAAAAARgAAAABUhQAA AQAAAAQAAAA5LjAAAwAmgAggBgAAAAAAwAAAAAAAAEYAAAAAAYUAAAAAAAALAC+ACCAGAAAAAADA AAAAAAAARgAAAAAOhQAAAAAAAAMAMIAIIAYAAAAAAMAAAAAAAABGAAAAABGFAAAAAAAAAwAygAgg BgAAAAAAwAAAAAAAAEYAAAAAGIUAAAAAAAAeAEGACCAGAAAAAADAAAAAAAAARgAAAAA2hQAAAQAA AAEAAAAAAAAAHgBCgAggBgAAAAAAwAAAAAAAAEYAAAAAN4UAAAEAAAABAAAAAAAAAB4AQ4AIIAYA AAAAAMAAAAAAAABGAAAAADiFAAABAAAAAQAAAAAAAAALANaACCAGAAAAAADAAAAAAAAARgAAAAAG hQAAAAAAAAsA2oAIIAYAAAAAAMAAAAAAAABGAAAAAIKFAAABAAAAAgH4DwEAAAAQAAAAC4K1Tqs6 vxGWfhKtrqXi6gIB+g8BAAAAEAAAAAuCtU6rOr8Rln4Sra6l4uoCAfsPAQAAAFAAAAAAAAAAOKG7 EAXlEBqhuwgAKypWwgAAUFNUUFJYLkRMTAAAAAAAAAAATklUQfm/uAEAqgA32W4AAABDOlxXSU5E T1dTXG91dGxvb2sucHN0AAMA/g8FAAAAAwANNP03AAACAX8AAQAAADQAAAA8TFBCQkpHSE9CSkNQ QkxPTEVKTkFHRUhLREZBQS5qb2huLmhhbGxhc0BtYWlsLmNvbT4AAwAGEDWqKQoDAAcQ1QAAAAMA EBAAAAAAAwAREAAAAAAeAAgQAQAAAGUAAABDQU5BTllCT0RZSEVMUE1FSURFTlRJRllXSEVOQU5J TkRFWFdBU0xBU1RCVUlMVFBMRUFTRUlDQU5URUxMV0hFTkFOSU5ERVhXQVNDUkVBVEVET1JERExD SEFOR0VERlJPTVVTAAAAAC0L Received on Tue Jan 02 2001 - 09:07:39 CST

Original text of this message

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