Re: Q1: Parallel Index Creation and Next Extents Allocation

I don't know about whitepapers, but basically each pq slave behaves as if it is creating the index on a subset of the data, and allocates extents accordingly (i.e. using the minextents, initial, next, pctincrease supplied) completely independently of all the others.

When all the pq slaves are finished, the query coordinator picks up all the separate segments generated, links them together as a single segment, then trims the last extent of each separate segment down to its high water mark.

(Based on Oracle 7.3.2.2).

---
Jonathan Lewis