Re: Creating indexes in parallel

Hi Stephan,

   I made two tests with the example I mentioned (one with parallel clause and one without it). In the first case, Oracle allocates 400 MB for the index; in the second, Oracle allocates 300 MB. So, Iīm wondering if this 100 MB in the first case would still be used. If Oracle cut the unused space off, I didntī see it on the dba_segments view.

Regards,
Carlos

> Hi Carlos,
>
> each of the 4 processes will allocate a 100MB extent, mark it as temp and
> start creating the index. At the end, each process cuts the unused space off
> the extent. So there will be three free spaces between the 4 extents (at
> least if the index fits in 4 extents).
> If this free space can be used in the future depends on its size and the
> extent sizes of the objects in this tablespace.
>
> Regards
> Stephan
>
> "Carlos Alberto" <calberto2312_at_hotmail.com> wrote in message
> news:72954535.0205161140.5cb7bac7_at_posting.google.com...
> > Hi,
> >
> > I have a doubt about creating indexes in parallel : suppose that I
> > put a degree of 4 with 100MB extents, then Oracle will allocate 4
> > processes to create the index. So, I would need at least 400 MB free
> > in the tablespace. But if the index only needs 300 MB, for example,
> > after itīs created, this space left (100 MB) would still be used in
> > the future insertions of data on this table?
> >
> > Thanks in advanced,
> > Carlos
Received on Fri May 17 2002 - 09:15:30 CDT