Home » RDBMS Server » Performance Tuning » Not used index
Not used index [message #65339] Wed, 11 August 2004 03:16 Go to next message
Tomasz
Messages: 13
Registered: May 2004
Junior Member
How to diagnose which index is not used?? How to monitor this??

I have oracle 8.1.7. 
Re: Not used index [message #65341 is a reply to message #65339] Wed, 11 August 2004 03:58 Go to previous message
Daljit Singh
Messages: 290
Registered: October 2003
Location: Texas
Senior Member
Hi,

Use this clause to determine whether Oracle should monitor index use.

Specify ALTER INDEX ... MONITORING USAGE to begin monitoring the index. Oracle first clears existing information on index usage, and then monitors the index for use until a subsequent ALTER INDEX ... NOMONITORING USAGE statement is executed.

To terminate monitoring of the index, specify NOMONITORING USAGE.

To see whether the index has been used since this ALTER INDEX ... NOMONITORING USAGE statement was issued, query the USED column of the V$OBJECT_USAGE dynamic performance view.

Daljit Singh
Previous Topic: update query in to stored procedure
Next Topic: Cost Based Indexes
Goto Forum:
  


Current Time: Thu Mar 28 07:29:25 CDT 2024