代码改变世界

关闭Oracle 11g的DPR特性

2017-04-18 11:29  AlfredZhao  阅读(...)  评论(...编辑  收藏

关闭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,需要重启库生效:

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> 
SQL> startup
ORACLE instance started.

Total System Global Area  313159680 bytes
Fixed Size                  2252824 bytes
Variable Size             222302184 bytes
Database Buffers           83886080 bytes
Redo Buffers                4718592 bytes
Database mounted.
Database opened.

SQL> show parameter event

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
event                                string      10949 trace name context forev
                                                 er,level 1
xml_db_events                        string      enable