8.1.6
>From: "Jack C. Applewhite" <japplewhite_at_inetprofit.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: RE: LAST REBUILD INDEX
>Date: Mon, 01 Apr 2002 10:17:42 -0800
>
>Seema,
>
>What version are you on? For 8.1.7.3.0 under Win2k Last_DDL_Time in
>DBA_Objects *does* show when an Index last had an "Alter Index <xxx>
>Rebuild" executed against it. I just now tested to verify that.
>
>Jack
>--------------------------------
>Jack C. Applewhite
>Database Administrator/Developer
>OCP Oracle8 DBA
>iNetProfit, Inc.
>Austin, Texas
>www.iNetProfit.com
>japplewhite_at_inetprofit.com
>(512)327-9068
>
>
>-----Original Message-----
>Sent: Monday, April 01, 2002 11:42 AM
>To: Multiple recipients of list ORACLE-L
>
>
>Jack
>No!
>thx
>-Seema
>
>
> >From: "Jack C. Applewhite" <japplewhite_at_inetprofit.com>
> >Reply-To: ORACLE-L_at_fatcity.com
> >To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> >Subject: RE: LAST REBUILD INDEX
> >Date: Mon, 01 Apr 2002 08:53:33 -0800
> >
> >Seema,
> >
> >Probably Last_DDL_Time in DBA_Objects, though that just tells you the
>last
> >time any DDL was executed on the object.
> >
> >Jack
> >
> >--------------------------------
> >Jack C. Applewhite
> >Database Administrator/Developer
> >OCP Oracle8 DBA
> >iNetProfit, Inc.
> >Austin, Texas
> >www.iNetProfit.com
> >japplewhite_at_inetprofit.com
> >(512)327-9068
> >
> >
> >-----Original Message-----
> >Sent: Monday, April 01, 2002 9:58 AM
> >To: Multiple recipients of list ORACLE-L
> >
> >
> >Hi
> >WHich view show when was the last rebuild of indexes?
> >Thx
> >-Seema
> >
>
>
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Jack C. Applewhite
> INET: japplewhite_at_inetprofit.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).
Chat with friends online, try MSN Messenger:
http://messenger.msn.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Seema Singh
INET: oracledbam_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).
Received on Mon Apr 01 2002 - 14:03:21 CST
