Info About Hidden Parameter _fix_control

刘泽宇

_FIX_CONTROL is a special hidden parameter introduced in 10.2.0.2

用法描述：

This parameter allows developers a mechanism to offer users the ability to disable certain bug fixes should they wish to. It is a generic service available to all layers but is mostly used by the optimizer code.

An example of how to use this parameter, documented in the header file qksbg.h where this parameter is defined, is as follows:


alter system set "_fix_control" = "3746511:OFF";

Executing the above command would disable the fix for unpublished Bug 3746511 if that would apply.

To determine which bug fixes have been altered one can select from the fixed views
GV$SYSTEM_FIX_CONTROL, GV$SESSION_FIX_CONTROL or their V$ counterparts