Doing some testing last night I ran a query with three DFO trees running
parallel 2,3, and 5 respectively, and dbms_xplan reported it as running
parallel 4. On average and rounding up ? ;)
Sent from my iPad
On 9 Dec 2015, at 14:49, Christian Antognini--
<Christian.Antognini@xxxxxxxxxxxx> wrote:
Hi Yasser
I read at many places that in version 12.1.0.2 Adaptive Dynamic Sampling
done due to Sql Plan Directive will be always at level 11, but
dbms_xplan.display_cursor doesn't refelct this truth.
This is because the information provided by dbms_xplan is wrong. Actually,
the content of v$sql_plan.other_xml is wrong.
The problem is that other_xml provides the level that was set during the
parse and not the level that was actually used by the query optimizer.
HTH
Chris Antognini
Troubleshooting Oracle Performance, Apress 2008/2014
http://top.antognini.ch
--
//www.freelists.org/webpage/oracle-l
