关闭Oracle 11g的DPR特性

关闭Oracle 11g的DPR（Direct Path Read）特性

查看event参数值：

SQL> show parameter event

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
event                                string
xml_db_events                        string      enable

设置10949 event,屏蔽DPR特性：

SQL> alter system set event='10949 trace name context forever,level 1' sid='*';
alter system set event='10949 trace name context forever,level 1' sid='*'
                 *
ERROR at line 1:
ORA-02095: specified initialization parameter cannot be modified


SQL> alter system set event='10949 trace name context forever,level 1' sid='*' scope=spfile;

System altered.

由于指定的scope=spfile，需要重启库生效：