DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: INDEX THAT IS NOT USED

  1. 07-10-2002, 09:48 AM #1
    Ablakios
    Ablakios is offline Senior Member
    Join Date
    Dec 2001
    Location
    Baltimore, MD
    Posts
    374
    Hi
    We are in process on restructuring/reorganizing the database and find out that DBA before has created many indexes on tables and lot of them are not needed and we want to drop them.

    How do we find index that are created on tables and yet are not used ?

    Thanks
    Arsene Lupain
    The lie takes the elevator, the truth takes the staircase but ends up catching up with the lie.
    Reply With Quote Reply With Quote
  2. 07-10-2002, 10:22 AM #2
    marist89's Avatar
    marist89
    marist89 is offline Super-Genius
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    What version?

    In 8i, the standard response is "use catio.sql", although I have had marginal results with catio. You can also periodically sample v$object_usage, but this method is only a sampling and not a complete view of what is being used over time. In short, there's no "Easy" way to do it in 8i.

    In 9i, you can use index monitoring. See http://otn.oracle.com/docs/products/...8a.htm#2113145 for details.
    Jeff Hunter
    Reply With Quote Reply With Quote
  3. 07-10-2002, 11:37 AM #3
    Ablakios
    Ablakios is offline Senior Member
    Join Date
    Dec 2001
    Location
    Baltimore, MD
    Posts
    374
    Jeff
    Thank you for the prompt response. In that case can you tell me how to get the list of duplicate index or table
    Thanks
    Arsene Lupain
    The lie takes the elevator, the truth takes the staircase but ends up catching up with the lie.
    Reply With Quote Reply With Quote
  4. 07-10-2002, 11:46 AM #4
    marist89's Avatar
    marist89
    marist89 is offline Super-Genius
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Look at dba_ind_columns
    Jeff Hunter
    Reply With Quote Reply With Quote
  5. 07-10-2002, 12:00 PM #5
    yoda
    yoda is offline Member
    Join Date
    May 2002
    Posts
    219
    This brings to mind:
    "Don't ever take a fence down until you know the reason why it was put up."
    -- Gilbert Keith Chesterton (1874-1936)
    yodaDBA@hotmail.com
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width