Re: Creating indexes in parallel

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 - 03:32:27 CDT