oracle 10513,设置10513事件禁止SMON恢复死事务

可以设置10513事件来临时禁止SMON恢复死事务，这在我们做某些异常恢复的时候显得异常有效，当然不建议在一个正常的生产环境中设置这个事件:

SQL> alter system set events '10513 trace name context forever, level 2';

System altered.

10531 -- event disables transaction recovery which was initiated by SMON

SQL> select ktuxeusn,

2 to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS') "Time",

3 ktuxesiz,

4 ktuxesta

5 from x$ktuxe

6 where ktuxecfl = 'DEAD';

KTUXEUSN Time KTUXESIZ KTUXESTA

---------- -------------------------- ---------- ----------------

17 24-JUN-2011 22:03:10 0 INACTIVE

66 24-JUN-2011 22:03:10 0 INACTIVE

105 24-JUN-2011 22:03:10 0 INACTIVE

193 24-JUN-2011 22:03:10 33361 ACTIVE

194 24-JUN-2011 22:03:10 0 INACTIVE

194 24-JUN-2011 22:03:10 0 INACTIVE

197 24-JUN-2011 22:03:10 20171 ACTIVE

7 rows selected.

SQL> /

KTUXEUSN Time KTUXESIZ KTUXESTA

---------- -------------------------- ---------- ----------------

17 24-JUN-2011 22:03:10 0 INACTIVE

66 24-JUN-2011 22:03:10 0 INACTIVE

105 24-JUN-2011 22:03:10 0 INACTIVE

193 24-JUN-2011 22:03:10 33361 ACTIVE

194 24-JUN-2011 22:03:10 0 INACTIVE

194 24-JUN-2011 22:03:10 0 INACTIVE

197 24-JUN-2011 22:03:10 20171 ACTIVE

7 rows selected.

================smon disabled trans recover trace==================

SMON: system monitor process posted

*** 2011-06-24 22:02:57.980

SMON: Event 10513 is level 2, trans recovery disabled.北京oracle培训：http://www.cuug.com/

阅读(1013) | 评论(0) | 转发(0) |