You are correct; the degree that is being
requested is 6.
Perhaps the author is thinking (incorrectly)
that you would get three slaves inserting and
three slaves selecting and has decided that
this means degree 3. Don't be fooled.
--
Jonathan Lewis
http://www.jlcomp.demon.co.uk
Host to The Co-Operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html
Author of:
Practical Oracle 8i: Building Efficient Databases
Screen saver or Life saver: http://www.ud.com
Use spare CPU to assist in cancer research.
DESANTIS77 wrote in message <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
Received on Fri Nov 23 2001 - 14:00:42 CST
