| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: When was an index last rebuilt?
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C07502.7305DFB0
Content-Type: text/plain;
charset="windows-1252"
Checked it, doesn't work.
Alex Hillman
-----Original Message-----
From: Rachel Carmichael [mailto:carmichr_at_hotmail.com]
Sent: Tuesday, January 02, 2001 2:52 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: When was an index last rebuilt?
I haven't checked this so I may be totally off-base here.... but dba_objects
has a column called timestamp which is the last time the object was changed.... I used to use it to find out when a package or a procedure had been changed. It MIGHT tell you when an index was rebuilt.
Caution: in Oracle7 it was a varchar2(75) column, in 8.1.6 they've gotten some sense and it's down to varchar2(19).
It MIGHT work.
Rachel
>From: Tim Onions <tim.onions_at_speechmachines.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: RE: When was an index last rebuilt?
>Date: Tue, 02 Jan 2001 08:25:47 -0800
>
>John
>
>I asked the same question of Oracle for Oracle7.3.4 and the answer was
>there
>is nowhere in the data dictionary to tell you when the index was last
>rebuilt. I've looked and looked in Oracle8 but still cannot find anything
>(I'd love to be proved wrong on that, anybody?).
>
>Regards
>
>-----Original Message-----
>Sent: 02 January 2001 15:10
>To: Multiple recipients of list ORACLE-L
>
>
>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
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Tim Onions
> INET: tim.onions_at_speechmachines.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: Rachel Carmichael INET: carmichr_at_hotmail.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). ------_=_NextPart_001_01C07502.7305DFB0 Content-Type: text/html; charset="windows-1252" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Dwindows-1252"> <META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2448.0"> <TITLE>RE: When was an index last rebuilt?</TITLE> </HEAD> <BODY> <P><FONT SIZE=3D2>Checked it, doesn't work.</FONT> </P> <P><FONT SIZE=3D2>Alex Hillman</FONT> </P> <P><FONT SIZE=3D2>-----Original Message-----</FONT> <BR><FONT SIZE=3D2>From: Rachel Carmichael [<A = HREF=3D"mailto:carmichr_at_hotmail.com">mailto:carmichr_at_hotmail.com</A>]</F= ONT> <BR><FONT SIZE=3D2>Sent: Tuesday, January 02, 2001 2:52 PM</FONT> <BR><FONT SIZE=3D2>To: Multiple recipients of list ORACLE-L</FONT> <BR><FONT SIZE=3D2>Subject: RE: When was an index last rebuilt?</FONT> </P> <BR> <P><FONT SIZE=3D2>I haven't checked this so I may be totally off-base = here.... but dba_objects </FONT> <BR><FONT SIZE=3D2>has a column called timestamp which is the last time = the object was </FONT> <BR><FONT SIZE=3D2>changed.... I used to use it to find out when = a package or a procedure had </FONT> <BR><FONT SIZE=3D2>been changed. It MIGHT tell you when an index was = rebuilt.</FONT> </P> <P><FONT SIZE=3D2>Caution: in Oracle7 it was a varchar2(75) column, in = 8.1.6 they've gotten </FONT> <BR><FONT SIZE=3D2>some sense and it's down to varchar2(19).</FONT> </P> <P><FONT SIZE=3D2>It MIGHT work.</FONT> </P> <P><FONT SIZE=3D2>Rachel</FONT> </P> <BR> <P><FONT SIZE=3D2>>From: Tim Onions = <tim.onions_at_speechmachines.com></FONT> <BR><FONT SIZE=3D2>>Reply-To: ORACLE-L_at_fatcity.com</FONT> <BR><FONT SIZE=3D2>>To: Multiple recipients of list ORACLE-L = <ORACLE-L_at_fatcity.com></FONT> <BR><FONT SIZE=3D2>>Subject: RE: When was an index last = rebuilt?</FONT> <BR><FONT SIZE=3D2>>Date: Tue, 02 Jan 2001 08:25:47 -0800</FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>>John</FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>>I asked the same question of Oracle for = Oracle7.3.4 and the answer was </FONT> <BR><FONT SIZE=3D2>>there</FONT> <BR><FONT SIZE=3D2>>is nowhere in the data dictionary to tell you = when the index was last</FONT> <BR><FONT SIZE=3D2>>rebuilt. I've looked and looked in Oracle8 but = still cannot find anything</FONT> <BR><FONT SIZE=3D2>>(I'd love to be proved wrong on that, = anybody?).</FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>>Regards</FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>>-----Original Message-----</FONT> <BR><FONT SIZE=3D2>>Sent: 02 January 2001 15:10</FONT> <BR><FONT SIZE=3D2>>To: Multiple recipients of list ORACLE-L</FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>>Can anybody help me identify when an index was = last built please</FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>>I can tell when an index was created or ddl = changed from user_indexes but I</FONT> <BR><FONT SIZE=3D2>>cannot see any way of telling when the = index was last built. Has anybody</FONT> <BR><FONT SIZE=3D2>>any thoughts on this please.</FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>>Thanks in advance</FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>>John</FONT> <BR><FONT SIZE=3D2>>--</FONT> <BR><FONT SIZE=3D2>>Please see the official ORACLE-L FAQ: <A = HREF=3D"http://www.orafaq.com" = TARGET=3D"_blank">http://www.orafaq.com</A></FONT> <BR><FONT SIZE=3D2>>--</FONT> <BR><FONT SIZE=3D2>>Author: Tim Onions</FONT> <BR><FONT SIZE=3D2>> INET: = tim.onions_at_speechmachines.com</FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>>Fat City Network Services -- = (858) 538-5051 FAX: (858) 538-5051</FONT> <BR><FONT SIZE=3D2>>San Diego, = California -- Public Internet = access / Mailing Lists</FONT> <BR><FONT = SIZE=3D2>>-----------------------------------------------------------= ---------</FONT> <BR><FONT SIZE=3D2>>To REMOVE yourself from this mailing list, send = an E-Mail message</FONT> <BR><FONT SIZE=3D2>>to: ListGuru_at_fatcity.com (note EXACT spelling of = 'ListGuru') and in</FONT> <BR><FONT SIZE=3D2>>the message BODY, include a line containing: = UNSUB ORACLE-L</FONT> <BR><FONT SIZE=3D2>>(or the name of mailing list you want to be = removed from). You may</FONT> <BR><FONT SIZE=3D2>>also send the HELP command for other information = (like subscribing).</FONT> </P> <P><FONT = SIZE=3D2>_______________________________________________________________= __</FONT> <BR><FONT SIZE=3D2>Get your FREE download of MSN Explorer at <A = HREF=3D"http://explorer.msn.com" = TARGET=3D"_blank">http://explorer.msn.com</A></FONT> </P> <P><FONT SIZE=3D2>-- </FONT> <BR><FONT SIZE=3D2>Please see the official ORACLE-L FAQ: <A = HREF=3D"http://www.orafaq.com" = TARGET=3D"_blank">http://www.orafaq.com</A></FONT> <BR><FONT SIZE=3D2>-- </FONT> <BR><FONT SIZE=3D2>Author: Rachel Carmichael</FONT> <BR><FONT SIZE=3D2> INET: carmichr_at_hotmail.com</FONT> </P> <P><FONT SIZE=3D2>Fat City Network Services -- (858) = 538-5051 FAX: (858) 538-5051</FONT> <BR><FONT SIZE=3D2>San Diego, = California -- Public Internet = access / Mailing Lists</FONT> <BR><FONT = SIZE=3D2>---------------------------------------------------------------= -----</FONT> <BR><FONT SIZE=3D2>To REMOVE yourself from this mailing list, send an = E-Mail message</FONT> <BR><FONT SIZE=3D2>to: ListGuru_at_fatcity.com (note EXACT spelling of = 'ListGuru') and in</FONT> <BR><FONT SIZE=3D2>the message BODY, include a line containing: UNSUB = ORACLE-L</FONT> <BR><FONT SIZE=3D2>(or the name of mailing list you want to be removed =Received on Tue Jan 02 2001 - 15:24:50 CST
 |
 |