Oracle Database - _FIX_CONTROL Optimizer Parameter

Card Puncher Data Processing

Dynamic View

_FIX_CONTROL is a special hidden parameter introduced in 10.2.0.2 which can be used to enable or disable certain bug fixes.

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.

A full list of bug numbers which are controlled by fix control can be found in the V$ views:

  1. VSYSTEM_FIX_CONTROL
  2. VSESSION_FIX_CONTROL

Control

  • Alter session
alter session set "_fix_control"='8855396:OFF';
  • Hint:
/*+ OPT_PARAM(‘_fix_control’ ’9195582:0′) */

Documentation / Reference







Share this page:
Follow us:
Task Runner