RE: best way to identify an unused index

From: <Paula_Stankus_at_doh.state.fl.us>
Date: Thu, 12 May 2005 14:03:06 -0400
Message-ID: <E518A02B320C8D4E97D99A8C546480210C3EB0A0@dohsmailhq01.doh.ad.state.fl.us>

OK in 9i much easier per Tom Kyte: Any performance hit on using this?

select=20
index_name,monitoring,used,start_monitoring,end_monitoring 2 from v$object_usage;

no rows selected

ops$tkyte_at_ORA920.US.ORACLE.COM>
ops$tkyte_at_ORA920.US.ORACLE.COM>
ops$tkyte_at_ORA920.US.ORACLE.COM> alter index t_pk monitoring usage

2 /

Index altered.

ops$tkyte_at_ORA920.US.ORACLE.COM>
ops$tkyte_at_ORA920.US.ORACLE.COM> select=20 index_name,monitoring,used,start_monitoring,end_monitoring 2 from v$object_usage;

INDEX_NAME MONITORING USED START_MONITORING END_MONITORING
------------ ---------- ---- ------------------- -------------------
T_PK YES NO 05/26/2003 10:06:32 ops$tkyte_at_ORA920.US.ORACLE.COM>
ops$tkyte_at_ORA920.US.ORACLE.COM> set echo off

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

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Stankus, Paula G Sent: Thursday, May 12, 2005 1:58 PM
To: arivenes_at_llnl.gov; dba.orcl_at_gmail.com; oracle-l_at_freelists.org Subject: RE:best way to identify an unused index

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

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

BEGIN-ANTISPAM-VOTING-LINKS

Teach CanIt if this mail (ID 32179039) is spam: Spam:
https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3Ds&i=3D32179039&m=3Dccc5= c6629
316
Not spam:
https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3Dn&i=3D32179039&m=3Dccc5= c6629
316
Forget vote:
https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3Df&i=3D32179039&m=3Dccc5= c6629
316

END-ANTISPAM-VOTING-LINKS
--

http://www.freelists.org/webpage/oracle-l Received on Thu May 12 2005 - 14:07:43 CDT