Re: Parallel Query Option

ERenner932 wrote:
>
> In creating a table using PARALLEL (DEGREE N) and setting the MINEXTENTS
> to N, shouldn't this table be creating in N extents across N files, as
> defined within the tablespace?

It would be nice...

In fact by setting degree N, you get N processes which think they alone are creating the table: they know nothing about the other N-1 processes, so they all:

1. pick space wherever they can
2. set their own MINEXTENTS to N

When all the parallel slaves are done, they pass the resulting N temporary segments to the query co-ordinator which trims off the unused extents (back to a minimum of MINEXTENTS) and also trims the unused space off the end of any incompletely used extents. Received on Tue Mar 04 1997 - 00:00:00 CST