| 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 is a multi-part message in MIME format.
------=_NextPart_000_000D_01C074CE.9AABF6E0 Content-Type: text/plain;
charset="Windows-1252"
Content-Transfer-Encoding: 7bit
RE: When was an index last rebuilt? Check Last_DDL_Time in DBA_OBJECTS.
Rama
-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Alex Hillman
Sent: Tuesday, January 02, 2001 1:36 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: When was an index last rebuilt?
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_000_000D_01C074CE.9AABF6E0 Content-Type: text/html; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3DWindows-1252"> <TITLE>RE: When was an index last rebuilt?</TITLE> <META content=3D"MSHTML 5.50.4207.2601" name=3DGENERATOR></HEAD> <BODY> <DIV><SPAN class=3D134321223-02012001><FONT face=3D"Comic Sans MS" = color=3D#008080=20 size=3D2> Check Last_DDL_Time in DBA_OBJECTS.</FONT></SPAN></DIV> <DIV><SPAN class=3D134321223-02012001><FONT face=3D"Comic Sans MS" = color=3D#008080=20 size=3D2></FONT></SPAN> </DIV> <DIV><SPAN class=3D134321223-02012001><FONT face=3D"Comic Sans MS" = color=3D#008080=20 size=3D2>Rama</FONT></SPAN></DIV> <DIV class=3DOutlookMessageHeader dir=3Dltr align=3Dleft><FONT = face=3DTahoma=20 size=3D2>-----Original Message-----<BR><B>From:</B> root_at_fatcity.com=20 [mailto:root_at_fatcity.com]<B>On Behalf Of </B>Alex = Hillman<BR><B>Sent:</B>=20 Tuesday, January 02, 2001 1:36 PM<BR><B>To:</B> Multiple recipients of = list=20 ORACLE-L<BR><B>Subject:</B> RE: When was an index last=20 rebuilt?<BR><BR></FONT></DIV> <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=20 Carmichael [<A=20 href=3D"mailto:carmichr_at_hotmail.com">mailto:carmichr_at_hotmail.com</A>]</FO= NT>=20 <BR><FONT size=3D2>Sent: Tuesday, January 02, 2001 2:52 PM</FONT> = <BR><FONT=20 size=3D2>To: Multiple recipients of list ORACLE-L</FONT> <BR><FONT = size=3D2>Subject:=20 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=20 dba_objects </FONT><BR><FONT size=3D2>has a column called timestamp = which is the=20 last time the object was </FONT><BR><FONT size=3D2>changed.... I = used to use=20 it to find out when a package or a procedure had </FONT><BR><FONT = size=3D2>been=20 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=20 they've gotten </FONT><BR><FONT size=3D2>some sense and it's down to=20 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=20 <tim.onions_at_speechmachines.com></FONT> <BR><FONT = size=3D2>>Reply-To:=20 ORACLE-L_at_fatcity.com</FONT> <BR><FONT size=3D2>>To: Multiple = recipients of list=20 ORACLE-L <ORACLE-L_at_fatcity.com></FONT> <BR><FONT = size=3D2>>Subject: RE:=20 When was an index last rebuilt?</FONT> <BR><FONT size=3D2>>Date: Tue, = 02 Jan=20 2001 08:25:47 -0800</FONT> <BR><FONT size=3D2>></FONT> <BR><FONT=20 size=3D2>>John</FONT> <BR><FONT size=3D2>></FONT> <BR><FONT = size=3D2>>I asked=20 the same question of Oracle for Oracle7.3.4 and the answer was = </FONT><BR><FONT=20 size=3D2>>there</FONT> <BR><FONT size=3D2>>is nowhere in the data = dictionary=20 to tell you when the index was last</FONT> <BR><FONT = size=3D2>>rebuilt. I've=20 looked and looked in Oracle8 but still cannot find anything</FONT> = <BR><FONT=20 size=3D2>>(I'd love to be proved wrong on that, anybody?).</FONT> = <BR><FONT=20 size=3D2>></FONT> <BR><FONT size=3D2>>Regards</FONT> <BR><FONT=20 size=3D2>></FONT> <BR><FONT size=3D2>>-----Original = Message-----</FONT>=20 <BR><FONT size=3D2>>Sent: 02 January 2001 15:10</FONT> <BR><FONT = size=3D2>>To:=20 Multiple recipients of list ORACLE-L</FONT> <BR><FONT = size=3D2>></FONT>=20 <BR><FONT size=3D2>></FONT> <BR><FONT size=3D2>>Can anybody help = me identify=20 when an index was last built please</FONT> <BR><FONT = size=3D2>></FONT>=20 <BR><FONT size=3D2>>I can tell when an index was created or ddl = changed from=20 user_indexes but I</FONT> <BR><FONT size=3D2>>cannot see any way = of =20 telling when the index was last built. Has anybody</FONT> <BR><FONT=20 size=3D2>>any thoughts on this please.</FONT> <BR><FONT = size=3D2>></FONT>=20 <BR><FONT size=3D2>>Thanks in advance</FONT> <BR><FONT = size=3D2>></FONT>=20 <BR><FONT size=3D2>></FONT> <BR><FONT size=3D2>>John</FONT> = <BR><FONT=20 size=3D2>>--</FONT> <BR><FONT size=3D2>>Please see the official = ORACLE-L FAQ:=20 <A target=3D_blank = href=3D"http://www.orafaq.com">http://www.orafaq.com</A></FONT>=20 <BR><FONT size=3D2>>--</FONT> <BR><FONT size=3D2>>Author: Tim = Onions</FONT>=20 <BR><FONT size=3D2>> INET: = tim.onions_at_speechmachines.com</FONT>=20 <BR><FONT size=3D2>></FONT> <BR><FONT size=3D2>>Fat City Network=20 Services -- (858) 538-5051 FAX: (858) = 538-5051</FONT>=20 <BR><FONT size=3D2>>San Diego,=20 California -- Public Internet = access /=20 Mailing Lists</FONT> <BR><FONT=20 size=3D2>>------------------------------------------------------------= --------</FONT>=20 <BR><FONT size=3D2>>To REMOVE yourself from this mailing list, send = an E-Mail=20 message</FONT> <BR><FONT size=3D2>>to: ListGuru_at_fatcity.com (note = EXACT=20 spelling of 'ListGuru') and in</FONT> <BR><FONT size=3D2>>the message = BODY,=20 include a line containing: UNSUB ORACLE-L</FONT> <BR><FONT = size=3D2>>(or the=20 name of mailing list you want to be removed from). You may</FONT>=20 <BR><FONT size=3D2>>also send the HELP command for other information = (like=20 subscribing).</FONT> </P> <P><FONT=20 size=3D2>________________________________________________________________= _</FONT>=20 <BR><FONT size=3D2>Get your FREE download of MSN Explorer at <A = target=3D_blank=20 href=3D"http://explorer.msn.com">http://explorer.msn.com</A></FONT> </P> <P><FONT size=3D2>-- </FONT><BR><FONT size=3D2>Please see the official = ORACLE-L FAQ:=20 <A target=3D_blank = href=3D"http://www.orafaq.com">http://www.orafaq.com</A></FONT>=20 <BR><FONT size=3D2>-- </FONT><BR><FONT size=3D2>Author: Rachel = Carmichael</FONT>=20 <BR><FONT size=3D2> INET: carmichr_at_hotmail.com</FONT> </P> <P><FONT size=3D2>Fat City Network Services -- (858)=20 538-5051 FAX: (858) 538-5051</FONT> <BR><FONT size=3D2>San Diego,=20 California -- Public Internet = access /=20 Mailing Lists</FONT> <BR><FONT=20 size=3D2>----------------------------------------------------------------= ----</FONT>=20 <BR><FONT size=3D2>To REMOVE yourself from this mailing list, send an = E-Mail=20 message</FONT> <BR><FONT size=3D2>to: ListGuru_at_fatcity.com (note EXACT = spelling of=20 'ListGuru') and in</FONT> <BR><FONT size=3D2>the message BODY, include a = line=20 containing: UNSUB ORACLE-L</FONT> <BR><FONT size=3D2>(or the name of =Received on Tue Jan 02 2001 - 17:13:44 CST
 |
 |