取arw报告.doc

4.15.7、生成数据库的ARW的报告 AWR ASH报告收集也是比较简单的 一下为实例： 1、AWR 报告的收集 $ sqlplus / as sysdba(首先在操作上以ORACLE用户登录，并且以SYS登录数据库) SQL*Plus: Release 10.2.0.1.0 - Production on Wed Dec 24 14:57:53 2008 Copyright (c) 1982, 2005, Oracle. All rights reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production With the Partitioning, Real Application Clusters, OLAP and Data Mining options SQL @?/rdbms/admin/awrrpt.sql;(执行这个SQL就可以开始AWR报告收集) Current Instance ~~~~~~~~~~~~~~~~ DB Id DB Name Inst Num Instance ----------- ------------ -------- ------------ 3704746844 HS08 1 HS081 Specify the Report Type ~~~~~~~~~~~~~~~~~~~~~~~ Would you like an HTML report, or a plain text report? Enter html for an HTML report, or text for plain text Defaults to html Enter value for report_type:(首先会提示你输入生成报告类型，默认为HTML，所以回车就OK) Type Specified: html Instances in this Workload Repository schema ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ DB Id Inst Num DB Name Instance Host ------------ -------- ------------ ------------ ------------ 3704746844 2 HS08 HS082 hp102 * 3704746844 1 HS08 HS081 hp101 Using 3704746844 for database Id Using 1 for instance number Specify 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 without specifying a number lists all completed snapshots. Enter value for num_days: 1 (输入快照查看的间隔，一般一天的就OK，实际根据HS DBA的要求来做) Listing the last days Completed Snapshots Snap Instance DB Name Snap Id Snap Started Level ------------ ------------ --------- ------------------ ----- HS081 HS08 158 24 Dec 2008 00:00 1 159 24 Dec 2008 01:00 1