DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 13 of 13

Thread: Rebuild indexes

  1. #11
    Join Date
    May 2002
    Oh, THAT issue again - separate TS for tables and indexes, never the twain shall meet. I think the latest understanding of that is it doesn't matter for the most part.

    But, 1500 indexes? That seems like an awful lot, and too many can actually degrade performance. Are they all being used? v$object_usage view in 9i, turn monitoring on. I bet there are hundreds not being used.

  2. #12
    Join Date
    Aug 2002
    Colorado Springs
    Maybe they're all in the SYSTEM tablespace -- that'd be a pretty good reason for moving them.

    Unless they belonged to SYS of course.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  3. #13
    Join Date
    Apr 2001
    Brisbane, Queensland, Australia
    Or maybe they are locally partitioned indexes on a partitioned table, which is paritioned on the days in a year... who knows...
    OCP 8i, 9i DBA
    Brisbane Australia

Posting Permissions

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

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.