STATSPACK and AWR Statistics Comparison

In a previous chapter, it was shown that many of the internal AWR tables have similar structure to the corresponding STATSPACK tables that store snapshots of the same v$ dynamic views. This supports the statement that the AWR is the next evolution of the STATSPACK utility. This similarity enables the easy conversion of existing performance reports originally designed for STATSPACK to new AWR views. Table 3.1 from Chapter 3 of this book contains a list of equivalent tables in the STATSPACK and AWR repositories.

 

The AWR repository holds all of the statistics available in STATSPACK as well as some additional statistics which are not. The following information on statistics is specific to those stored in the AWR that are not part of the STATSPACK.

 

STATSPACK does not store the Active Session History  (ASH) statistics available in the AWR dba_hist_active_sess_history view. The ASH allows DBAs to perform time-series analyses of wait events for a particular session history.

 

An important difference between STATSPACK and the AWR is that STATSPACK does not store history for new metric statistics introduced in Oracle10g. The key AWR views, dba_hist_sysmetric_history  and dba_hist_sysmetric_summary , help the DBA build time-series reports for important database performance metrics such as Total Time Waited or Response Time Per Txn.

 

The AWR also contains views such as dba_hist_service_stat , dba_hist_service_wait_class and dba_hist_service_name , which store history for performance cumulative statistics tracked for specific services.

 

The latest version of STATSPACK included with Oracle10g contains a set of specific tables, which track history of statistics that reflect the performance of the Oracle Streams feature. These tables are stats$streams_capture , stats$streams_apply_sum , stats$buffered_subscribers , stats$rule_set , stats$propagation_sender , stats$propagation_receiver  and stats$buffered_queues . The AWR does not contain the specific tables that reflect Oracle Streams activity; therefore, if a DBA relies heavily on the Oracle Streams feature, it would be useful to monitor its performance using STATSPACK utility.

 

 

AWR包括STATSPACK的所有统计信息。AWR还包括以下STATSPACK没有的统计信息。

 

STATSPACK不保存ASH统计， AWR中 dba_hist_active_sess_history view保存，ASH允许DBA一个历史时期的基于时间的等待事件的分析。

 

STATSPACK and the AWR一个重要的区别是STATSPACK不包含10g中新增的统计信息dba_hist_sysmetric_history  and dba_hist_sysmetric_summary这两个视图帮助DBA报告Total Time Waited or Response Time Per Txn的统计信息。

 

 AWR还包括dba_hist_service_stat , dba_hist_service_wait_class and dba_hist_service_name的统计某些专有服务历史的性能信息。

最新的STATSPACK包括Streams的特征统计。stats$streams_capture , stats$streams_apply_sum , stats$buffered_subscribers , stats$rule_set , stats$propagation_sender , stats$propagation_receiver  and stats$buffered_queuesAWR中不包括所以想使用统计反映Stream最好还是使用Statspack