Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Rebuilding Indexes (Tuning it?)
The first step, from your comments, is to
use the UNRECOVERABLE option on creating
the index so that no redo is generated for the
index itself (although a little will occur as the
dictionary space management takes place).
--
Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk
NetComrade wrote in message <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 - 11:12:59 CDT