报警日志报了一次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
请问这是什么问题呢?
怎么结决阿
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/