Re: Parallel hint
From: raja <dextersunil_at_gmail.com>
Date: Fri, 13 Feb 2009 00:05:25 -0800 (PST)
Message-ID: <a1afadf5-c08e-4a76-a851-876b8833522b_at_p20g2000yqi.googlegroups.com>
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 )
Date: Fri, 13 Feb 2009 00:05:25 -0800 (PST)
Message-ID: <a1afadf5-c08e-4a76-a851-876b8833522b_at_p20g2000yqi.googlegroups.com>
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.
Received on Fri Feb 13 2009 - 02:05:25 CST