Rebuilding indexes

If it's a worry about space, have a look at ALTER INDEX COALESCE:
http://download-uk.oracle.com/docs/c...8a.htm#2050689

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

Rebuild or Coalesce only for sequence keys.. and ofcourse where history data is purged regularly.. else no use..

Abhay.

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

Quote:

---

Originally Posted by stmontgo

yeah but LMT's do that implicitly anyway

---

talking about indexes here, not tablespaces