Re: Q1: Parallel Index Creation and Next Extents Allocation

From: Steve Bourgeois <sbourgeo_at_ici.net>
Date: 1997/01/15
Message-ID: <5bhe4d$j3r$1@bashir.ici.net>#1/1

In article <853253646.4553_at_dejanews.com>, vidya.shankar_at_firstdatacorp.com says...
>
>Hello All!,
>
>Are there white papers, information available on "Parallel Index Creation
>Process" and "how Oracle allocates next extents for this parallel index
>creation process"?
>

When you create an index in parallel with degree = N, you will initially have N temporary segments of size INITIAL created in your index tablespace.

When the index creation is complete, all of these temporary segments should be automagically typed as INDEX segments. After the index is created, extents of size NEXT would be allocated.

A couple of things to keep in mind:

Keep an eye on the sort_area_size init.ora parameter. Each parallel query process (N * 2) can potentially allocate this much memory.
If you are using version 7.2 of the Oracle 7 Server, consider using the sort_direct_writes functionality to improve performance.

Steve Received on Wed Jan 15 1997 - 00:00:00 CST