原帖由 jieyancai 于 2011-7-15 12:46 发表
竟然有6个死事务要恢复。
select ADDR,KTUXEUSN,KTUXESLT,KTUXESQN,KTUXESIZ from x$ktuxe where KTUXECFL='DEAD';
select sid,username,sql_id,sql_hash_value from v$session where taddr in(select ADDR from x$ktuxe where KTUXECFL='DEAD');
SQL> select ADDR,KTUXEUSN,KTUXESLT,KTUXESQN,KTUXESIZ from x$ktuxe where KTUXECFL='DEAD';
ADDR
KTUXEUSN KTUXESLT KTUXESQN KTUXESIZ
---------------- ---------- ---------- ---------- ----------
9FFFFFFFEF5AA9B8
3
41117310
0
9FFFFFFFEF5AB828
3 461117307
0
9FFFFFFFEF5AA960105
3 108539
0
9FFFFFFFEF5AB460122 3543183
0
9FFFFFFFEF5AA9B8130
410376
0
9FFFFFFFEF5AA858132
0 3342
0
6 rows selected.
SQL> select sid,username,sql_id,sql_hash_value from v$session where taddr in(select ADDR from x$ktuxe where KTUXECFL='DEAD');
no rows selected |