RE: best way to identify an unused index
- From: <Paula_Stankus@xxxxxxxxxxxxxxx>
- To: <Paula_Stankus@xxxxxxxxxxxxxxx>, <arivenes@xxxxxxxx>, <dba.orcl@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 12 May 2005 14:03:06 -0400
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@xxxxxxxxxxxxxxxxxxxx>
ops$tkyte@xxxxxxxxxxxxxxxxxxxx>
ops$tkyte@xxxxxxxxxxxxxxxxxxxx> alter index t_pk monitoring usage
2 /
Index altered.
ops$tkyte@xxxxxxxxxxxxxxxxxxxx>
ops$tkyte@xxxxxxxxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxxxxxxxx>
ops$tkyte@xxxxxxxxxxxxxxxxxxxx> set echo off
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Stankus, Paula G
Sent: Thursday, May 12, 2005 1:58 PM
To: arivenes@xxxxxxxx; dba.orcl@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: RE:best way to identify an unused index
In Oracle 9i what is the best way to identify an unused index?
--
//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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
