首页 > 代码库 > 【练习】手工生成awr报告

【练习】手工生成awr报告

①首先进入$ORACLE_HOME/rdbms/admin目录

[oracle@host02 ~]$ cd $ORACLE_HOME/rdbms/admin

该目录下

[oracle@host02 admin]$ ls -l awrrpt.sql-rw-r--r-- 1 oracle oinstall 1999 Oct 24  2003 awrrpt.sql

以SYSDBA身份登录运行@awrrpt 

SQL>  @awrrptCurrent Instance~~~~~~~~~~~~~~~~   DB Id    DB Name      Inst Num Instance----------- ------------ -------- ------------  241462155 ORA11GR2            1 ORA11GR2Specify the Report Type~~~~~~~~~~~~~~~~~~~~~~~Would you like an HTML report, or a plain text report?Enter html for an HTML report, or text for plain textDefaults to htmlEnter value for report_type: Type Specified:  htmlInstances in this Workload Repository schema~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~   DB Id     Inst Num DB Name      Instance     Host------------ -------- ------------ ------------ ------------* 241462155         1 ORA11GR2     ORA11GR2     host02Using  241462155 for database IdUsing          1 for instance numberSpecify the number of days of snapshots to choose from~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~Entering the number of days (n) will result in the most recent(n) days of snapshots being listed.  Pressing <return> withoutspecifying a number lists all completed snapshots.Enter value for num_days: 1Listing the last days Completed Snapshots                                                        SnapInstance     DB Name        Snap Id    Snap Started    Level------------ ------------ --------- ------------------ -----ORA11GR2     ORA11GR2            19 15 Oct 2016 18:37      1                                 20 15 Oct 2016 19:00      1Specify the Begin and End Snapshot Ids~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~Enter value for begin_snap: 19Begin Snapshot Id specified: 19Enter value for end_snap: 20End   Snapshot Id specified: 20Specify the Report Name~~~~~~~~~~~~~~~~~~~~~~~The default report file name is awrrpt_1_19_20.html.  To use this name,press <return> to continue, otherwise enter an alternative.Enter value for report_name: Using the report name awrrpt_1_19_20.html

 

【练习】手工生成awr报告