Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2009

    Angry Unanswered: How to find unused indexes in 9i

    We have a table that has more than 16 col indexes built. I am not sure if they are used. How can I find out which indexes are not being

  2. #2
    Join Date
    Aug 2003
    Where the Surf Meets the Turf @Del Mar, CA
    Provided Answers: 1
    When all else fails, Read The Fine Manual


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

    Specify 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.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts