Re: In 12.1.0.2 ADS due to SPD will be always at level 11
- From: Christian Antognini <Christian.Antognini@xxxxxxxxxxxx>
- To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>, "necht.stefan@xxxxxxxxx" <necht.stefan@xxxxxxxxx>
- Date: Wed, 9 Dec 2015 14:53:37 +0000
Hi Stefan
AFAIK it only does change it to 11 on its own if optimizer_dynamic_sampling
is left at the default value.
This is only the case when dynamic sampling is enabled because of parallel
processing.
If dynamic sampling is enabled because of a SQL plan directive, as of 12.1.0.2
the level 11 is used.
HTH
Chris Antognini
Troubleshooting Oracle Performance, Apress 2008/2014
http://top.antognini.ch
--
//www.freelists.org/webpage/oracle-l
Other related posts: