比如等待中也有
SQL> select * from v$waitstat;
CLASS COUNT TIME
------------------ ---------- ----------
data block 2 1
sort block 0 0
save undo block 0 0
segment header 1 0
save undo header 0 0
free list 0 0
extent map 0 0
1st level bmb 0 0
2nd level bmb 0 0
3rd level bmb 0 0
bitmap block 0 0
CLASS COUNT TIME
------------------ ---------- ----------
bitmap index block 0 0
file header block 0 0
unused 0 0
system undo header 0 0
system undo block 0 0
undo header 0 0
undo block 0 0
已选择18行。
SQL>
在 x$bh.class 中
5 : save undo segment header
3:save undo block
其表示的是defferd rollback segment 的 block (参考oracle concepts)
SQL> select count(*) from x$bh where class = 3;
COUNT(*)
----------
0
SQL> select count(*) from x$bh where class = 5;
COUNT(*)
----------
0
SQL> delete rainy.t where rownum < 11;
已删除10行。
SQL> alter tablespace users offline;
表空间已更改。
SQL> select count(*) from x$bh where class = 5;
COUNT(*)
----------
1
SQL> select count(*) from x$bh where class = 3;
COUNT(*)
----------
1
SQL> alter tablespace users online;
表空间已更改。
SQL> select count(*) from rainy.t;
COUNT(*)
----------
90
SQL> select count(*) from x$bh where class = 5;
COUNT(*)
----------
0
SQL> select count(*) from x$bh where class = 3;
COUNT(*)
----------
0
SQL>