ITPub博客

首页 > Linux操作系统 > Linux操作系统 > How to use the Automatic Database Diagnostic Monitor(一)

How to use the Automatic Database Diagnostic Monitor(一)

原创 Linux操作系统 作者:zhanglei_itput 时间:2009-05-20 14:58:27 0 删除 编辑

Oracle9i and before, DBA may access Oracle performance statistics by using tools such as STATSPACK;
In Oracle 10g, the database by default takes Automatic Workload Repository (AWR) snapshots 。

1. AWR(Automatic Workload Repository)
    AWR data is flushed from memory to disk using internal kernel calls and a dedicated background process (MMON). 
    Data collecting doesn't require manual configuration, like Statspack snapshots in previous releases.
    AWR provides automatic purging of data (7 days by default) 
    AWR snapshots can be preserved so that they are not purged
    EXECUTE dbms_workload_repository.create_snapshot();

2.ASH (Active Session History) 
    collects samples of active sessions every second

3.ADDM(Automatic Database Diagnostic Monitor)
   ADDM is a powerful self-diagnostic engine ,ADDM is invoked automatically every time that a new AWR snapshot is generated.
   Manually generate a new ADDM report:
   $ORACLE_HOME/rdbms/admin/addmrpt.sql

4.Use AWR rather than statspack
   because:
   The repository is created and maintained automatically 
   The report can be generated in text or html mode 
   The report displays additional information regarding wait classes, metrics, OS stats, etc
   To generate an AWR report :
   $ORACLE_HOME/rdbms/admin/awrrpt.sql

参考文献:
   1.Note 276103.1- PERFORMANCE TUNING USING 10g ADVISORS AND MANAGEABILITY FEATURES
  2.Note 250655.1 - How to use the Automatic Database Diagnostic Monitor
  3.http://www.oracle.com/technology/obe/10gr2_db_single/manage/addm/addm_otn.htm

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

请登录后发表评论 登录
全部评论

注册时间:2009-02-10

  • 博文量
    400
  • 访问量
    1129038