1、进入sqlplus

[oracle@localhost admin]$ sqlplus / as sysdbaSQL*Plus: Release 11.2.0.3.0 Production on Mon Jun 11 11:03:31 2018Copyright (c) 1982, 2011, Oracle.  All rights reserved.Connected to:Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsSQL>

 2、执行awr生成sql

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

 

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

本次输入：起始 313   结束 335

 

使用默认名称直接回车

 

生成完毕！