Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Rebuilding Indexes (Tuning it?)

Rebuilding Indexes (Tuning it?)

From: NetComrade <andreyNSPAM_at_bookexchange.net>
Date: Mon, 26 Jul 1999 15:51:23 GMT
Message-ID: <379c835e.6656402@news.earthlink.net>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US