External Views (33)

最新推荐文章于 2024-12-03 09:39:19 发布

转载最新推荐文章于 2024-12-03 09:39:19 发布 · 113 阅读

本文介绍如何通过V$TRANSACTION、V$ROLLSTAT及V$UNDOSTAT视图来监控Oracle数据库中的事务和回滚信息。这些视图提供了关于自动回滚管理、事务并发度、查询长度等关键统计数据，帮助管理员评估当前工作负载下所需的回滚表空间大小。

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@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/10599713/viewspace-970455/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/10599713/viewspace-970455/