Re: Rebuilding Indexes (Tuning it?)

From: Ulrik Hoffmann <ulrik_at_hoffmann-kiel.de>
Date: Mon, 26 Jul 1999 18:27:42 +0100
Message-ID: <7ni2b9$h0e$1@freeside.cls.net>

Hi,

if you have the storage parameters, which you mentioned in the other mail (initial 250M next 50M), the db has to allocate 250MB for rebuilding the index. This is maybe the reason for the long time. You need a big temorary tablespace as well. What about the redo-logs?
There are some basic tips on
http://www.hoffmann-kiel.de/stdinst.html

Bye
Uli

NetComrade <andreyNSPAM_at_bookexchange.net> schrieb in im Newsbeitrag: 379c835e.6656402_at_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 - 12:27:42 CDT