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 |
@zztat_oracle
