Oracle参数之event 10513

我们设置Oracle参数event 10513将禁止smon进程进行事务回滚。在进行trouble shooting时，如shutdown abort后设置该速度可以加快数据库的open速度，注意加快速度的同时，也可能带来数据库一致性问题，或者smon在进行并行恢复（ Parallel query）时消耗100%CPU，有了该参数有了更多的选择余地。该参数可以在系统级别设置（需重启数据库），当然也可以针对smon进程进行设置，以下就是设置过程：

查询smon进程号：
[quote]SQL> select pid, program from v$process where program like '%SMON%';

PID PROGRAM
---------- ------------------------------------------------
8 oracle@mcprod (SMON)[/quote]

针对smon进程进行参数设置
[quote]SQL> oradebug setorapid 8;
Unix process pid: 11482, image: oracle@mcprod (SMON)
SQL> oradebug event 10513 trace name context forever, level 2
Statement processed.[/quote]

关闭event参数
[quote]SQL> oradebug event 10513 trace name context off
Statement processed.[/quote]
下面看一下Oracle官方对于event 10513解释，该文件存放在
$ORACLE_HOME/rdbms/mesg/oraus.msg文件中。
[quote]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.[/quote]