一点一滴努力,满仓满谷收成

用于调整优化器行为。
1 相关视图

SELECT DISTINCT BUGNO, VALUE, SQL_FEATURE, DESCRIPTION, EVENT, IS_DEFAULT
FROM V$SESSION_FIX_CONTROL
WHERE OPTIMIZER_FEATURE_ENABLE = ‘11.2.0.4’;

2 调整方式
on 11.2.0.4:

alter session set “_fix_control” =’12341619:OFF’;
Or
Using hint /*+ OPT_PARAM(‘_fix_control’,’12341619:OFF’) */

On 11.2.0.3:

alter session set “_fix_control” =’11814428:OFF’;
Or
Using hint /*+ OPT_PARAM(‘_fix_control’,’11814428:OFF’) */