oracle awr检查报告.doc

oracle awr检查报告 报告采集说明 Awr报告可以总体反映oracle数据库的信息和运行情况，帮助快速定位数据库问题。 建议生成业务高峰时段报告，如：8:00 -17:00 生成awr报告方式： 在服务器上以sysdba用户登录数据库 sqlplus / as sysdba 运行以下脚本 SQL@?/rdbms\admin\awrrpt Current Instance ~~~~~~~~~~~~~~~~ DB Id DB Name Inst Num Instance ----------- ------------ -------- ------------ 1265912605 ORCL 1 orcl 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格式 Type Specified: html Instances in this Workload Repository schema ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ DB Id Inst Num DB Name Instance Host ------------ -------- ------------ ------------ ------------ * 1265912605 1 ORCL orcl IBMT60 Using 1265912605 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 --输入要查看几天的快照，我们选一天 Snap Instance DB Name Snap Id Snap Started Level ------------ ------------ --------- ------------------ ----- orcl ORCL 293 10 May 2011 9:01 1 294 10 May 2011 10:00 1 295 11 May 2011 11:00 1 Specify the Begin and End Snapshot Ids ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Enter value for begin_snap: Specify the Begin and End Snapshot Ids ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Enter value for begin_snap: 294 --报告开始时间对应的快照编号 Begin Snapshot Id specified: 294 Enter value for end_snap: 295 End Snapshot Id specified: 295 --报告结束时间对应的快照编号 Specify the Re