What is the command used for monitoring a index on a table to find out whether it has been used by an execution plan?

Interview Candidate
Oct 2nd, 2004
4
1378

First
Prev
Next
Last

Showing Answers 1 - 4 of 4 Answers

udayasrinu
Profile Answers by udayasrinu

Feb 9th, 2008

select * from v$object_usage

krishnaprasad.sola
Profile Answers by krishnaprasad.sola Questions by krishnaprasad.sola

Feb 10th, 2009

To enable monitoring index

Alter index <index name> monitoring usage;

This command will update the V$object_usage view.After mointoring we can use this view to know wheter the index is used or unused.

To disable monitoring index

Alter index <index name> nomonitoring usage;