Oracle数据库性能分析-生成AWR报告

生成awr报告

1、进入数据库 sqlplus / as sysdba

2、开始压测后执行 exec DBMS_WORKLOAD_REPOSITORY.CREATE_SNAPSHOT ();   

3、 结束压测后执行 exec DBMS_WORKLOAD_REPOSITORY.CREATE_SNAPSHOT ();

4、输入命令 @?\rdbms\admin\awrrpt.sql

SQL> @D:\app\Administrator\product\11.2.0\dbhome_1\RDBMS\ADMIN\awrrpt.sql

Current Instance

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'

Type Specified: html

Specify the Begin and End Snapshot Ids

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Listing the last day's Completed Snapshots

INST_NAME DB_NAME SNAP_ID SNAPDAT LV

------------ ------------ -------- ------------------ --

orcl ORCL 20692 08 Jan 2020 00:00 1

orcl ORCL 20693 08 Jan 2020 01:00 1

orcl ORCL 20694 08 Jan 202