Category监控

SYSAUX表空间中SM/AWR, SM/ADVISOR, SM/OPTSTAT and SM/OTHER的介绍

SYSAUX表空间中SM/AWR, SM/ADVISOR, SM/OPTSTAT and SM/OTHER的介绍

SYSAUX表空间中很多组件都可以被移动到其它表空间,但是有些对象却无法移动,例如SM/AWR, SM/ADVISOR, SM/OPTSTAT and SM/OTHER

SM/AWR
==============================================
Automatic Workload Repository
配置信息可以查询下面视图
select * from DBA_HIST_WR_CONTROL;
Continue reading

awr对于sysaux表空间使用率的诊断

awr是SYSAUX表空间的大客户,要了解sysaux的使用情况,我们除了查询v$sysaux_occupants外,还可以利用oracle自带的脚本AWRINFO.sql

SQL> @$ORACLE_HOME/rdbms/admin/AWRINFO.sql

如下这块值得关注:

*************************************
(2) Size estimates for AWR snapshots
*************************************
|
| Estimates based on 60 mins snapshot INTERVAL:
| AWR size/day 39.9 MB (1,704 K/snap * 24 snaps/day)
| AWR size/wk 279.5 MB (size_per_day * 7) per instance
|
| Estimates based on 14 snaps in past 24 hours:
| AWR size/day 23.3 MB (1,704 K/snap and 14 snaps in past 24 hours)
| AWR size/wk 163.0 MB (size_per_day * 7) per instance
Continue reading

© 2019 Init dba

Theme by Anders NorenUp ↑