Re: Parallel hint

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Sat, 14 Feb 2009 22:24:37 -0000
Message-ID: <HsmdnS7Kdr4-2QrUnZ2dnUVZ8tvinZ2d_at_bt.com>

"raja" <dextersunil_at_gmail.com> wrote in message news:2d1d5633-3af9-4008-b28b-6ac589cda2e0_at_g1g2000pra.googlegroups.com...
> Hi,
>
> I have table with parallel degree 4.
> I altered the table with parallel degree 8.
> But the insert query of that table didnt take the parallel process of
> 8, though i forced the parallel hint with 8. Instead it is taking
> parallel degree 4.
>
> Note 1 : i also used alter session parallel....
> Note 2 : i also took the explain plan of the insert query with
> parallel degree 4 and 8, there was no difference
>
> Can anyone tel me what could be the reason why the insert statement
> didnt take the parallel degree 8, though i altered the table with
> parallel degree 8 and also forced parallel hint with degree 8 ?
>
> With Regards,
> Raja.
>

Have you enabled parallel DML ?

It looks like you are doing insert/select - Do you know which bit is going parallel, the insert, the select, or both ? Have you checked the execution plan, and the v$pq_stat view after running the insert ?

-- 
Regards

Jonathan Lewis
http://jonathanlewis.wordpress.com

Author: Cost Based Oracle: Fundamentals
http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Received on Sat Feb 14 2009 - 16:24:37 CST