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 : 可获得当前工作负载需要的回滚表空间 ， 使用率等信息
来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/10599713/viewspace-970455/，如需转载，请注明出处，否则将追究法律责任。