首页 > 代码库 > 【练习】手工生成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 ‘html‘Enter 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 day‘s 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报告
声明:以上内容来自用户投稿及互联网公开渠道收集整理发布,本网站不拥有所有权,未作人工编辑处理,也不承担相关法律责任,若内容有误或涉及侵权可进行投诉: 投诉/举报 工作人员会在5个工作日内联系你,一经查实,本站将立刻删除涉嫌侵权内容。