Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Degree in parallel hint is not working properly.

976208Feb 1 2013 — edited Feb 1 2013
Hi Experts,

I am using the following delete statement.

delete /*+ parallel(t,30) */ from master_header t;

Sometimes the degree 30 is not working.

On what basis we have to give the degree.
Is the degree is session specific?

To use this hint we need to follow any guidelines or check list.

Please help me.

Thanks.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 1 2013
Added on Feb 1 2013
4 comments
234 views