Have you tried building a test case with sql test case builder & running it
in 19c database? Just curious.
On Mon, 18 May 2020 at 20:51, Martin Berger <martin.a.berger@xxxxxxxxx>
I have a SQL query - in 12.1 it was using Adaptive Plan.
In 12.2 it isn't anymore. I don't see this a big problem, but would like
to be able to explain why.
Unfortunately I can not share the full 10053 trace, but I will be able to
copy&paste all relevant parts - just tell me what you are looking for.
some probably interesting parameters:
AP - adaptive plans
optimizer_adaptive_reporting_only = false
optimizer_adaptive_plans = true
optimizer_adaptive_statistics = false
optimizer_features_enable = 22.214.171.124
I'm curious regarding these lines:
AP: Checking validity for query block SEL$3, sqlid=0zc1a01zycagh
AP: Adaptive plans bypassed for query block SEL$3 due to materialized
AP: Adaptive joins bypassed for query block SEL$3 due to adaptive plans
? why is a MV block adaptive plans?
? where can I find why adaptive plans are disabled?
Again, this is more for me to understand, right now there is no issue ;-)
thanks for all hints,
Martin Berger Oracle ♠
martin.a.berger@xxxxxxxxx @martinberx <https://twitter.com/martinberx>