oracle查询删除进度,请问v$transaction查看回滚进度,与V$FAST_START_TRANSACTIONS查看回滚进度的区别...

V$FAST_START_TRANSACTIONS

V$FAST_START_TRANSACTIONS displays information about the progress of the transactions that Oracle is recovering.

V$TRANSACTION

V$TRANSACTION lists the active transactions in the system.

SQL> delete ll;

75277 rows deleted.

SQL> shutdown abort;

ORACLE instance shut down.

SQL>

SQL>

SQL> startup;

ORACLE instance started.

Total System Global Area 939495424 bytes

Fixed Size 2260800 bytes

Variable Size 415236288 bytes

Database Buffers 515899392 bytes

Redo Buffers 6098944 bytes

Database mounted.

Database opened.

SQL> select * from V$transaction;

no rows selected

SQL> select * from V$FAST_START_TRANSACTIONS;

USN SLT SEQ STATE UNDOBLOCKSDONE

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

UNDOBLOCKSTOTAL PID CPUTIME PARENTUSN PARENTSLT PARENTSEQ

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

XID PXID RCVSERVERS

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

6 9 1302 RECOVERED 2177

2177 3

0600090016050000 8

SQL> select * from V$FAST_START_TRANSACTIONS;

USN SLT SEQ STATE UNDOBLOCKSDONE

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

UNDOBLOCKSTOTAL PID CPUTIME PARENTUSN PARENTSLT PARENTSEQ

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

XID PXID RCVSERVERS

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

6 9 1302 RECOVERED 2177

2177 3

0600090016050000 8V$FAST_START_TRANSACTIONS; 仅在 OPEN DATABASE的 dead transaction recovery时被填充， 此时V$TRANSACTION 没有记录 因为实际 只有死事务被恢复 而非active transaction

详细参考了解你所不知道的SMON功能(五):Recover Dead transaction http://www.askmaclean.com/archives/smon-recover-dead-transaction.html