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

Thread: Rebuilding indexes

  1. #11
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    If it's a worry about space, have a look at ALTER INDEX COALESCE:
    http://download-uk.oracle.com/docs/c...8a.htm#2050689
    "The power of instruction is seldom of much efficacy except in those happy dispositions where it is almost superfluous" - Gibbon, quoted by R.P.Feynman

  2. #12
    Join Date
    Mar 2002
    Location
    Mesa, Arizona
    Posts
    1,204
    Hey DaPi,

    I concur. I've found coalescing especially helpful to free up blocks with sequential indexes where alot of deleting is going on.

    I have a locking problem when coalescing a table with alot of inserts going on at the same time. When it gets to the end of the index blocking locks will bring the db to its knees.

    Oracle support swears it can't happen, but I can reproduce a lock-down every time. I have to be careful to only run the coalesce for 8 or 10 hours then kill it. Archiving goes crazy after a few hours. That's when I know it is actually merging blocks.

    Ken
    "I do not fear computers. I fear the lack of them." Isaac Asimov
    Oracle Scirpts DBA's need

  3. #13
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    Rebuild or Coalesce only for sequence keys.. and ofcourse where history data is purged regularly.. else no use..

    Abhay.
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

  4. #14
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187
    Quote Originally Posted by DaPi
    If it's a worry about space, have a look at ALTER INDEX COALESCE:
    http://download-uk.oracle.com/docs/c...8a.htm#2050689
    yeah but LMT's do that implicitly anyway
    I'm stmontgo and I approve of this message

  5. #15
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    Quote Originally Posted by stmontgo
    yeah but LMT's do that implicitly anyway
    talking about indexes here, not tablespaces

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