关闭 Oracle 11g 的 DPR(Direct Path Read)特性
查看 event 参数值:
- SQL> showparametereventNAME TYPE VALUE------------------------------------ ----------- ------------------------------
- event string
- xml_db_events string enable
设置 10949 event, 屏蔽 DPR 特性:
- SQL> alter systemset event='10949 trace name context forever,level 1'sid='*';
- alter systemset event='10949 trace name context forever,level 1'sid='*'*
- ERROR at line1:
- ORA-02095: specified initialization parameter cannot be modified
- SQL> alter systemset 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 Area313159680bytes
- FixedSize 2252824bytes
- VariableSize 222302184bytes
- Database Buffers83886080bytes
- Redo Buffers4718592bytes
- Database mounted.
- Databaseopened.
- SQL> showparametereventNAME TYPE VALUE------------------------------------ ----------- ------------------------------
- event string10949tracenamecontext forev
- er,level1xml_db_events string enable
来源: http://www.linuxidc.com/Linux/2017-04/143140.htm