On 12.1 and facing performance problems ?

It might be related to Adaptive Features which are a set of capabilities that enable the optimizer to make run-time adjustments to execution plans and to adjust plans for future executions based on the results of previous executions.

Please check Mike’s Blog so you can apply the 12.2 behaviour on 12.1 DB.

https://mikedietrichde.com/2016/11/23/enabling-adaptive-features-of-oracle-12-2-in-12-1/

Hopefully, patches 22652097 and 21171382 will be incorporated in the next database proactive bundle patch. So keep checking MOS note 1937782.1.

Check the options available to you depending on what you’re upgrading from: https://blogs.oracle.com/optimizer/entry/optimizer_adaptive_features_and_upgrading

 

 

Author: reguchi

Oracle ACE, OCP 12c, OCE 12c MAA, OCE Exadata, RHCE, AWS CSAA, OCI CSAA. Technology geek, homebrewer, dad.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s