Degree in parallel hint is not working properly.
976208Feb 1 2013 — edited Feb 1 2013Hi 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.