Re: Sql Profile 12c
From: Stefan Knecht <knecht.stefan_at_gmail.com>
Date: Fri, 8 Dec 2017 13:08:11 +0700
Message-ID: <CAP50yQ_+RcXnG1UN3hQX976sb8caUr+GMqU4h9ZT=dhBabjXSw_at_mail.gmail.com>
Date: Fri, 8 Dec 2017 13:08:11 +0700
Message-ID: <CAP50yQ_+RcXnG1UN3hQX976sb8caUr+GMqU4h9ZT=dhBabjXSw_at_mail.gmail.com>
There are several bugs on 12.1.0.2 related to the adaptive optimizer and its choices. Many environments have it actually turned off for that reason.
Are you running the latest proactive bundle patches?
Also have a look at this note, which (on top of the bundle patches) recommends patches to avoid such problems: Things to Consider to Avoid Poor Performance or Wrong Results on 12.1.0.2 (Doc ID 2034610.1)
Stefan
-- // zztat - The Next-Gen Oracle Performance Monitoring and Reaction Framework! Visit us at zztat.net | Support our Indiegogo campaign at igg.me/at/zztat | _at_zztat_oracle -- http://www.freelists.org/webpage/oracle-lReceived on Fri Dec 08 2017 - 07:08:11 CET