Oracle 修改 optimizer_dynamic_sampling 参数方法

查看当前参数值

SQL> show parameter OPTIMIZER_DYNAMIC_SAMPLING;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
optimizer_dynamic_sampling           integer     2

修改参数值为 4

SQL> alter system  set optimizer_dynamic_sampling=4;

System altered.

查看修改结果

SQL> show parameter OPTIMIZER_DYNAMIC_SAMPLING;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
optimizer_dynamic_sampling           integer     4

至此，optimizer_dynamic_sampling 参数值修改成功 。