Re: Alter index xxx rebuild partitions

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Mon, 31 Mar 2003 20:52:05 +1000
Message-ID: <iWUha.3674$1s1.52185@newsfeeds.bigpond.com>

"chan01" <chandra_2000_us_at_yahoo.com> wrote in message news:480cb9d4.0303282321.621457a2_at_posting.google.com...
> i would like to know how much time app. it will take
> alter index xxx rebuild partition ix_jun02.
> i did for 5 GB data partition it took me 73 minutes.
>
> I am using SunFire 3800 with 8x750MHz + 8 GB RAM. Oracle 816.

Approximately 48 minutes, 23.74 seconds providing:

the wind is generally from a south easterly direction
it's a full moon (although a fullish one should suffice)
the data doesn't contain too many long words which are notoriously difficult to rebuild (such as transmogrification)
you pat the server gently whilst humming the tune to Dr Who

or else it could be significantly longer (or shorter).

Good Luck ;)

Richard Received on Mon Mar 31 2003 - 04:52:05 CST