ITPub博客

首页 > IT基础架构 > 网络安全 > External Views (33)

External Views (33)

原创 网络安全 作者:tsinglee 时间:2007-09-20 17:15:59 0 删除 编辑

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/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
  • 博文量
    740
  • 访问量
    1892919