RE: HOW TO KNOW INDEX NOT IN USE?

[Shaw John-P55297]

Title: RE: HOW TO KNOW INDEX NOT IN USE?

I can get it.

-----Original Message-----
From: Aponte, Tony [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 05, 2002 11:21 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: HOW TO KNOW INDEX NOT IN USE?

Nope.  Same behavior for me.

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 05, 2002 11:01 AM
To: Multiple recipients of list ORACLE-L
Subject: 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�������DCTL������ka�ɚ�X��X��ǧu��1����,j­ ���k���­r+rr���ׄ\�����)���Ѯ��v)�鞲� x�b)ܖ�^jX�y�'����x5%
9,B��^�������X��X��*.������­騽�_�����ɩl�ǧv�^B�r��jw_��-����+��b�yb��.n�+���