Re: Running time of index rebuild
From: rjamya <rjamya_at_gmail.com>
Date: Wed, 5 Jun 2013 14:00:08 -0400
Message-ID: <CAGurbTN4f30=qoMrhgCR61Jai3yEcqRjU71TutsdKk=Jy+DZBg_at_mail.gmail.com>
I may be wrong, but wouldn't you need a whole new temporary segment for rebuild in addition to existing index? so you might actually use more space until rebuild operation is complete. And if you have maintenance window, why not just drop old one and re-create? So the new index will reuse recently freed space as well?
Raj
Date: Wed, 5 Jun 2013 14:00:08 -0400
Message-ID: <CAGurbTN4f30=qoMrhgCR61Jai3yEcqRjU71TutsdKk=Jy+DZBg_at_mail.gmail.com>
I may be wrong, but wouldn't you need a whole new temporary segment for rebuild in addition to existing index? so you might actually use more space until rebuild operation is complete. And if you have maintenance window, why not just drop old one and re-create? So the new index will reuse recently freed space as well?
Raj
On Wed, Jun 5, 2013 at 10:56 AM, Ingrid Voigt <giantpanda_at_gmx.net> wrote:
> My suggestion for the maintenance window prod would be 16 hours, do you
> have a better idea?
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Jun 05 2013 - 20:00:08 CEST