Re: Rebuilding Indexes (Tuning it?)

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Mon, 26 Jul 1999 17:12:59 +0100
Message-ID: <933009392.7562.0.nnrp-01.9e984b29@news.demon.co.uk>

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