| Not used index [message #65339] |
Wed, 11 August 2004 03:16  |
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  |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
