获取AWR报告

1、进入sqlplus

[oracle@localhost admin]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Mon Jun 11 11:03:31 2018

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


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL>

 2、执行awr生成sql

SQL> @ '$ORACLE_HOME/rdbms/admin/awrrpt.sql'

 

(后改为选择  2，即两天内)

本次输入：起始 313   结束 335

 

使用默认名称直接回车

 

生成完毕！