RE:best way to identify an unused index

I have been setting a select few of my indexes to 'monitoring usage' and=20= this is working for us=2E I have been able to identify several large=20= indexes that are never being used in our production database=2E I did=20= discover that gathering statistics causes the indexes to show as 'used' in=20= the v$object_usage table though so you have to be careful about when you=20= start and stop monitoring usage on the index=2E

So far we have not noticed any performance impact with monitoring usage=20= set on a few indexes at a time=2E

HTH, Patty

<Paula_Stankus_at_doh=2Estate=2Efl=2Eus>=20=
Sent by: oracle-l-bounce_at_freelists=2Eorg 2005/05/12 01:58 PM
Please respond to
Paula_Stankus_at_doh=2Estate=2Efl=2Eus

To
<arivenes_at_llnl=2Egov>, <dba=2Eorcl_at_gmail=2Ecom>, <oracle-l_at_freelists=2Eorg>
cc

Subject
RE:best way to identify an unused index

In Oracle 9i what is the best way to identify an unused index?

--
http://www=2Efreelists=2Eorg/webpage/oracle-l







----------------------------------------------------------

This e-mail is confidential, intended solely for the use of the
recipient(s) to whom it was addressed=2E If you have received it
in error, please do not copy or distribute this e-mail=2E We ask
that you notify us immediately by replying to the sender and
then delete this e-mail=2E E-mail sent or received over the
internet may not be secure=2E You should use caution when sending
e-mail messages containing private and confidential information
or consider other secure means to send the information=2E If you
have any questions regarding the authenticity or security of
e-mail you have received from Green Shield Canada please do not
hesitate to contact us at 1-800-265-5615=2E

Please visit us at our website:  http://www=2Egreenshield=2Eca


----------------------------------------------------------

Ce message de courriel est confidentiel et s=92adresse uniquement
=E0 la personne ou =E0 l=92organisme indiqu=E9(e)=2E  Si vous l=92avez re=E7u
par erreur, veuillez ne pas copier ni distribuer ce message de
courriel=2E  Nous vous demandons de nous aviser imm=E9diatement en
r=E9pondant =E0 l=92exp=E9diteur, puis en supprimant ce message=2E Les
messages envoy=E9s ou re=E7us par courriel pourraient ne pas =EAtre
s=E9curis=E9s=2E  Vous devriez =EAtre prudent lorsque vous envoyez des
messages de courriel contenant des renseignements confidentiels
et priv=E9s ou songer =E0 prendre d=92autres moyens s=E9curis=E9s pour
envoyer les renseignements=2E  Si vous avez des questions concernant
l=92authenticit=E9 ou la s=E9curit=E9 d=92un courriel que vous avez re=E7u de
Green Shield Canada, n=92h=E9sitez pas =E0 communiquer avec nous au
1-800-265-5615=2E

Visitez notre site Web:  http://www=2Egreenshield=2Eca

--
http://www.freelists.org/webpage/oracle-l