RE: HOW TO KNOW INDEX NOT IN USE?

[אדר יחיאל]

Hello John

I already send the article URL to the list.
I think that the members would like the URL
rather then : I can get it.

Yechiel Adar, Mehish Computer Services
[EMAIL PROTECTED]

> -----Original Message-----
> From: Shaw John-P55297 [SMTP:[EMAIL PROTECTED]]
> Sent: Tue, February 05, 2002 7:36 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:      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 
> 
> 
> 
> 
> 
>       &alef;&dalet;&resh; &yod;&het;&yod;&alef;&lamed; <[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š±&kaf;z?^!&qof;ℷr&¥9,B?
m¶Ÿ?? 
>       (§?©?&&kaf;a¢² 
>       2Z&het;R¶)e§b³+¢aZ´(???Š&he;I&fkaf;&fnun;??¬&fpe;Ÿ9??t&het;Q@_?|&het;9?Rjpℷz 
>       
> jXŸ¢¹ℷh?>-'ž?«&kaf;Zq?¬³&fpe;ŠX§EUR¸¬¶?&tet;DCTL¨÷»*&qof;&kaf;¢kaŠ?šŠX§'X¬¶?§u©?1¨¥(tm)&kaf;
> ,j ¸¬´k«¹&tsadi;r+rr?§¢?"\"²-¥-)&alef;!&ayin;ℷ²?®®&zayin;§v)&fmem;...&yod;ž²?
> xfb)?-&het;^jX§y?'µ¨§Šx5%
9,B&tet;®?^©ž!&shin;šŠX§'X¬·*.?©&fmem;¶??&yod;¨½&het;_®?~¢&yod;š?©l¢?§v?^
> B?r?¦jw_¢÷-...&fkaf;ℷ&tav;+(tm)«b¢yb'&kaf;.n?+?¸§
> 
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
>  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?&alef;&dalet;&resh;_&yod;&het;&yod;&alef;&lamed;?  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).