|
在RDBMS/admin目录下，awrinfo.sql是统计awr metadata的脚本，比如对awr snapshot每天/每周（快照收集间隔:60min）使用存储空间的趋势进行前期评估等，包括awr segment使用空间比较严重的报表等。用awrinfo.sql可以清楚地得知以下信息：
(I) AWR Snapshot Info gathering
(II) Advisor framework diagnostics
(III) AWR and ASH Usage Info Gathering awrinfo报表部分内容示例： *************************************
(2) Size estimates for AWR snapshots
*************************************
|
| Estimates based on 60 mins snapshot INTERVAL:
| AWR size/day 12.0 MB (513 K/snap * 24 snaps/day)
| AWR size/wk 84.2 MB (size_per_day * 7) per instance
|
| Estimates based on 10 snaps in past 24 hours:
| AWR size/day 5.0 MB (513 K/snap and 10 snaps in past 24 hours)
| AWR size/wk 35.1 MB (size_per_day * 7) per instance
|
