Oracle参数之event 10513
发布时间:[2012-4-10] 来源: 作者: 点击:
我们设置Oracle参数event 10513将禁止smon进程进行事务回滚。在进行trouble shooting时,如shutdown abort后设置该速度可以加快数据库的open速度,注意加快速度的同时,也可能带来数据库一致性问题,或者smon在进行并行恢复( Parallel query)时消耗100%CPU,有了该参数有了更多的选择余地。该参数可以在系统级别设置(需重启数据库),当然也可以针对smon进程进行设置,以下就是设置过程:
查询smon进程号:
引用
SQL> select pid, program from v$process where program like '%SMON%';
PID PROGRAM
---------- ------------------------------------------------
针对smon进程进行参数设置
引用
SQL> oradebug setorapid 8;
Unix process pid: 11482, image: oracle@mcprod (SMON)
SQL> oradebug event 10513 trace name context forever, level 2
Statement processed.
关闭event参数
引用
SQL> oradebug event 10513 trace name context off
Statement processed.
下面看一下Oracle官方对于event 10513解释,该文件存放在
$ORACLE_HOME/rdbms/mesg/oraus.msg文件中。
引用
10513, 00000, "turn off wrap source compression"
// *Cause:
// *Action: Set this event if you do not want source of wrapped PL/SQL
// objects to be concatenated and stored multiple lines to a row.
// *Comment: This event should be set if you want the source of wrapped
// PL/SQL objects to be stored one line per source row. The
// new storage method is multiple lines per row, which
// improves load and compile performance.
关键字: