Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Rebuilding Indexes (Tuning it?)
Is there are a way to tune rebuilding indexes? I try to rebuild a 30M
index, and it takes forever! (about 1/2 hour). I don't have PQO
installed (although I wish, I just need advice on installing it on a
live database). As I can see from my alert log, as soon as I start
index rebuilds I start getting crazy redo generated (I think I have
more of it generated then the size of my index). Well, anyway, any
help/feedback would be appreciated. Thanx
Received on Mon Jul 26 1999 - 10:51:23 CDT