Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: HOW TO KNOW INDEX NOT IN USE?

RE: HOW TO KNOW INDEX NOT IN USE?

From: Aponte, Tony <AponteT_at_hsn.net>
Date: Tue, 05 Feb 2002 09:25:52 -0800
Message-ID: <F001.004065DD.20020205092030@fatcity.com>

Nope. Same behavior for me.

-----Original Message-----

From: Jared.Still_at_radisys.com [mailto:Jared.Still_at_radisys.com]

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

<adary_at_mehish.co.il>

Sent by: root_at_fatcity.com

02/05/02 12:45 AM

Please respond to ORACLE-L

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>

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

adary_at_mehish.co.il

> -----Original Message-----

> From: Seema Singh [SMTP:oracledbam_at_hotmail.com]

> 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: 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).

> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

> 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: adary_at_mehish.co.il


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).




>Wz^r&9,Bm

(ک&a

2ZR)eb+aZ(׭ŠIǬ9tQ@_|9ӝRjpz

jXh'׫ZqǬXDCTLkaɚXXǧu1,jkr+rrׄ\)Ѯv)鞲Ơxb)ܖ^jXy'x5%9,B^XX*.ޭ騽_ɩlǧv^Brjw_-+byb.n+
Received on Tue Feb 05 2002 - 11:25:52 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US