Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Parallel index rebuilds: strange results?
On 19 Apr 1998 15:58:54 GMT, "Kevin Brand" <kbrand_at_gtetel.com> wrote:
>
>I've been re-building indexes with 'alter index rebuild' and have noticed
>that when I use a parallel clause, the final storage characteristics of the
>index are somewhat odd.
>
>The following statement should re-create the given index with 10 extents,
>each of which are 10 MB in size:
>
>alter index myindex rebuild storage ( initial 10M next 1024k ) parallel (
>degree 10 );
>
>While I get 10 extents, they are not 10M each. Here's the break down:
>
[...]
Hi Kevin,
AFAIK, when your're building indexes in parallel, then each slave process will start building into its own initial extent and afterwards, shrink it to the size that is actually used.
HTH,
Peter
--
Peter Schneider
peter.schneider_at_okay.net
Received on Sun Apr 19 1998 - 12:32:48 CDT