degree of parallelism

From: DESANTIS77 <desantis77_at_aol.com>
Date: 21 Nov 2001 17:54:01 GMT
Message-ID: <20011121125401.29629.00001033@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 Received on Wed Nov 21 2001 - 11:54:01 CST