Chinaunix首页 | 论坛 | 博客
  • 博客访问: 1089791
  • 博文数量: 178
  • 博客积分: 2776
  • 博客等级: 少校
  • 技术积分: 2809
  • 用 户 组: 普通用户
  • 注册时间: 2012-03-22 15:36
文章分类

全部博文(178)

文章存档

2014年(3)

2013年(66)

2012年(109)

分类: Oracle

2012-12-18 09:22:49

可以设置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 dba

阅读(1042) | 评论(0) | 转发(0) |
给主人留下些什么吧!~~