Parallel transaction recovery tried

72 阅读 0 评论 48 点赞

我是靠谱客的博主激昂糖豆，最近开发中收集的这篇文章主要介绍Parallel transaction recovery tried，觉得挺不错的，现在分享给大家，希望可以做个参考。

概述

报警日志报了一次SMON: Parallel transaction recovery tried

SQL> select b.object_name ,a.xidusn,a.xidslot,a.xidsqn,a.session_id,c.type,a.process,a.locked_mode f
rom v$locked_object a ,dba_objects b,v$lock c
  2  where a.object_id=b.object_id and a.object_id=c.id1;

OBJECT_NAME
--------------------------------------------------------------------------------
XIDUSN XIDSLOT    XIDSQN SESSION_ID TY PROCESS    LOCKED_MODE
---------- ---------- ---------- ---------- -- ------------ -----------
WS_FETCH_GOODS_DETAIL
      7       22    11896       507 TM                      3

WS_OPERATION_ORDER
      7       22    11896       507 TM                      3

WS_WAREHOUSE_IO
      7       22    11896       507 TM                      3

OBJECT_NAME
--------------------------------------------------------------------------------
XIDUSN XIDSLOT    XIDSQN SESSION_ID TY PROCESS    LOCKED_MODE
---------- ---------- ---------- ---------- -- ------------ -----------
WS_WAREHOUSE_IO_DETAIL
      7       22    11896       507 TM                      3

LP_TASK_ORDER
      7       22    11896       507 TM                      3

WS_FETCH_GOODS
      7       22    11896       507 TM                      3
请问这是什么问题呢?
怎么结决阿

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/8135069/viewspace-136024/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/8135069/viewspace-136024/