Re: In 12.1.0.2 ADS due to SPD will be always at level 11

From: Christian Antognini <Christian.Antognini_at_trivadis.com>
Date: Wed, 9 Dec 2015 14:53:37 +0000
Message-ID: <43D812FCDBAB8948B2F14F61C4B1CD0AFCDDB127_at_vaps205.trivadis.com>

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

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Dec 09 2015 - 15:53:37 CET

This message: [ Message body ]
Next message: Mark W. Farnham: "RE: securefiles licensing"
Previous message: Christian Antognini: "RE: In 12.1.0.2 ADS due to SPD will be always at level 11"
Maybe in reply to: Stefan Koehler: "Re: In 12.1.0.2 ADS due to SPD will be always at level 11"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message