Re: degree of parallelism

From: dias <ydias_at_hotmail.com>
Date: 23 Nov 2001 08:30:23 -0800
Message-ID: <55a68b47.0111230830.4c239d90@posting.google.com>

desantis77_at_aol.com (DESANTIS77) wrote in message news:<20011121132810.29621.00001101_at_mb-fv.aol.com>...
> I am preparing for an oracle dba exam and I came across something in my
> exam cram book that looked a little strange. If possible could you tell me what
> the degree of parallelism is for the following statement:
>
> insert /*+ PARALLEL(iarc,6) */ into invoice_archive iarc
> select * from sales where invoice_no < 10000;
>
>
> The book said that the degree of parallelism that is being requested is 3 but i
> thought that it should be 6.
>
> Thanks
>
> Dominick

Hi,

The degee of parallelism can be reduced by the number of the parallel processes. If you have only 3 processes, the degree will be 3 and not 6.

Dias Received on Fri Nov 23 2001 - 10:30:23 CST