Need to enable or disable certain bug fixes?

Yes, it is possible.

This is typically used in the optimizer area to allow specific fixes to be turned on or off as some fixes can have a significant  effect on execution plans.

_FIX_CONTROL is a special hidden dynamic parameter introduced in 10.2.0.2 which accomplishes exactly this.

The syntax for using _FIX_CONTROL is:

 

To enable:
“_fix_control”=’Bugno:ON’    (OR)   “_fix_control”=”Bugno:1”

To disable:
“_fix_control”=’Bugno:OFF’  (OR)   “_fix_control”=”Bugno:0”

Source: MOS note 827984.1

Also check Tim Hall website for more info:

https://oracle-base.com/articles/misc/granular-control-of-optimizer-features-using-fix-control

 

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