Re: In 12.1.0.2 ADS due to SPD will be always at level 11
From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Wed, 9 Dec 2015 20:05:43 +0000
Message-Id: <24CC4226-3CE4-4CF9-BD65-60784273C0A7_at_jlcomp.demon.co.uk>
>
> 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
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
Date: Wed, 9 Dec 2015 20:05:43 +0000
Message-Id: <24CC4226-3CE4-4CF9-BD65-60784273C0A7_at_jlcomp.demon.co.uk>
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_at_trivadis.com> 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
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Dec 09 2015 - 21:05:43 CET