External Views (33)

Monitor transaction and undo information with V$TRANSACTION and V$ROLLSTAT.
For automatic undo management, the information in V$ROLLSTAT reflects the
behaviors of the automatic undo management undo segments.
The V$UNDOSTAT view displays a histogram of statistical data to show how well the
system is working. You can see statistics such as undo consumption rate, transaction
concurrency, and lengths of queries run in the instance. Using this view, you can better
estimate the amount of undo space required for the current workload.

1. v$transaction : 事務
2. v$rollstat : 回滾資訊
3. v$undostat : 可獲得當前工作負載需要的回滾表空間 ， 使用率等資訊

[@more@]