Re: Sql Profile 12c

From: Stefan Knecht <>
Date: Fri, 8 Dec 2017 13:08:11 +0700
Message-ID: <>

There are several bugs on 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 (Doc ID 2034610.1)


zztat - The Next-Gen Oracle Performance Monitoring and Reaction Framework!
Visit us at | Support our Indiegogo campaign at |

Received on Fri Dec 08 2017 - 07:08:11 CET

Original text of this message