AWR报告的生成

AWR：Automatic Workload Repository-自动负载信息库，oracle 10g推出的新工具。

一.以DBA身份登陆数据库

[oracle@RedHat ~]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Sat Aug 10 11:04:32 2013

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> 

二.运行AWR生成脚本

SQL> @?/rdbms/admin/awrrpti.sql


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  ----（填写想要生成AWR的格式 enter）

Type Specified:  html




Instances in this Workload Repository schema  ---（这种工作模式下的实例）
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~


   DB Id                     Inst Num    DB Name    InstanceHost
------------                  -------------    ------------    ------------ ------------
* 1348795218            1                 ORCL     orcl      RedHat


Enter value for dbid: 1348795218  ----(选择要生成AWR报告的实例DBid)
Using 1348795218 for database Id