http://www.oracle.com/oramag/oracle/02-jan/index.html?o12o9index.html
HTH Francois > -----Message d'origine----- > De: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] > Date: mardi, 5. f�vrier 2002 17:01 > �: Multiple recipients of list ORACLE-L > Objet: RE: HOW TO KNOW INDEX NOT IN USE? > > Can anyone else get to this article? > > My browser gets redirected to > http://download-west.oracle.com/otndoc/oracle9i/901_doc/appdev.901/a89852/ > d_metada.htm#1656 > > Jared > > > > > > ??? ????? <[EMAIL PROTECTED]> > Sent by: [EMAIL PROTECTED] > 02/05/02 12:45 AM > Please respond to ORACLE-L > > > To: Multiple recipients of list ORACLE-L > <[EMAIL PROTECTED]> > cc: > Subject: RE: HOW TO KNOW INDEX NOT IN USE? > > > Hello Seema > > Oracle magazine for 01-02/2002 has on page 91 an article > that gives step by step instructions on this issue for 9i. > They also have a reference to: > http://www.oracle.com/oramag/oracle/jan02/metadata.html > > Yechiel Adar, Mehish Computer Services > [EMAIL PROTECTED] > > > -----Original Message----- > > From: Seema Singh [SMTP:[EMAIL PROTECTED]] > > Sent: Mon, February 04, 2002 7:55 PM > > To: Multiple recipients of list ORACLE-L > > Subject: HOW TO KNOW INDEX NOT IN USE? > > > > Hi > > I there any view which can tell us which indexes are not in use? > > Thx > > -Seema > > > > > > > > _________________________________________________________________ > > 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: [EMAIL PROTECTED] > > > > 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: [EMAIL PROTECTED] (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). > > -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- > > This e-mail was scanned by the eSafe Mail Gateway > > -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?= > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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). > > > > >W��?z?^�??r&�9,B?m��??(�?�?&?a�� > 2Z?R�)e�b�+�aZ�(???�?I????�?�9??t?Q@_?|?9?�Rjp?z > jX���?h?>-'�?��?Zq?��?�X�EUR���??DCTL���*??�ka�?��X�'X��?�u�?1��(tm)? > ,j ���k��?r+rr?��?"\"�-�-)?�??�?��?�v)?...?��? > xfb)?-?^jX�y?'����x5%9,B?�?^����?��X�'X��*.?�?�???��?_�?~�?�?�l�?�v?^ > B?r?�jw_��-...??�?+(tm)�b�yb'?.n?+?�� -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?Q?Gendre_Fran�ois? INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
