Hey Ram,
just trace your case with the following hidden parameter and you gonna see the
reason.
SQL> alter session set "_px_trace"=high,all;
For more information about "_px_trace" - please check out my blog post here:
http://tinyurl.com/oxcmyp2 ;
Best Regards
Stefan Koehler
Freelance Oracle performance consultant and researcher
Homepage: http://www.soocs.de
Twitter: @OracleSK
Ram Cheruvattath <ram.cheruvattath@xxxxxxxxx> hat am 23. Juni 2016 um 21:24--
geschrieben:
To clarify my statement below:
"However, any increase in parallel thereafter does not result in an
increase in slaves."
What I meant is "However, any increase in parallel thereafter does not
result in doubling of slaves."
In other words, increasing the parallelism for INSERT and SELECT to 8 does
not result in 16 slaves. It results in 8 slaves.
Ram