Re: Parallel hint
From: ddf <oratune_at_msn.com>
Date: Fri, 13 Feb 2009 08:18:22 -0800 (PST)
Message-ID: <b2535ea1-fdb2-4bfc-9c59-37d5db7e5f35_at_q35g2000vbi.googlegroups.com>
On Feb 13, 2:05 am, raja <dextersu..._at_gmail.com> wrote:
> Adding by observations :
> 1. when the insert is executed within a package, i can see p00 - p007
> ( degree 4 )
> 2. when the insert is executed outside the package, i can see p00 -
> p031 ( degree 16 )
> 3. if i alter the no parallel degree for table ( executing outside
> package ) and then alter session with parallel, i can see p00 - p031
> ( degree 16 )
> 4. Executing outside package with any degree of parallelism forced to
> the insert, i can see p00 - p031 ( degree 16 )
>
> Any ideas... Why is this problem ???
>
> With Regards,
> Raja.
Date: Fri, 13 Feb 2009 08:18:22 -0800 (PST)
Message-ID: <b2535ea1-fdb2-4bfc-9c59-37d5db7e5f35_at_q35g2000vbi.googlegroups.com>
On Feb 13, 2:05 am, raja <dextersu..._at_gmail.com> wrote:
> Adding by observations :
> 1. when the insert is executed within a package, i can see p00 - p007
> ( degree 4 )
> 2. when the insert is executed outside the package, i can see p00 -
> p031 ( degree 16 )
> 3. if i alter the no parallel degree for table ( executing outside
> package ) and then alter session with parallel, i can see p00 - p031
> ( degree 16 )
> 4. Executing outside package with any degree of parallelism forced to
> the insert, i can see p00 - p031 ( degree 16 )
>
> Any ideas... Why is this problem ???
>
> With Regards,
> Raja.
You're running which release of Oracle? Oh, you didn't say ... maybe you should, to all four to five numbers.
David Fitzjarrell Received on Fri Feb 13 2009 - 10:18:22 CST