10g awr与statspack区别

最新推荐文章于 2025-12-18 10:59:28 发布

转载最新推荐文章于 2025-12-18 10:59:28 发布 · 149 阅读

文章标签：

Oracle Database 10g引入了自动工作负载资料库(Automatic Workload Repository)和活动会话历史(Active Session History)，取代了之前的性能数据收集工具如Statspack和utlbstat/utlestat。新工具提供了自动化的数据解释和报告，能够进行主动监控并在问题发生前提供解决方案建议。此外，还能够在细粒度级别上检测问题，例如热点块或热点对象，并直接提供调优建议。

全文摘自http://xzh2000.itpub.net/post/96/66492

Oracle Database 10 genhances the data collection mechanism with the introduction of the Automatic Workload Repository and Active Session History, which replace the previous performance data gathering tools such as Statspack and utlbstat/utlestat. The major differences between the current repositories from previous such tools include the following:

■ Earlier tools had no automated way of interpreting the collected data and results produced by supplied reports. The raw data and the formatted output from the Statspack tool required manual interpretation.
■ There is no proactive monitoring in the earlier tools. The DBA could tune the database or solve the problem only after its occurrence. The Automatic Database Diagnostics Monitor (ADDM) tool in Oracle Database 10 g, detects a problem before it strikes and advises possible solutions.

■ ADDM works at a fine-grained level to detect problems at the database segment level. For example, if there is a hot block or hot object causing performance problems, ADDM identifies the object and provides tuning advice, while this information would not be directly captured in Statspack report.
■ Problems such as excessive logins and logoffs, ITL waits, and RAC-related service issues were not captured in the Statspack report, but ADDM captures this information and offers tuning advice.

[@more@]

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

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