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
使用默认名称直接回车
生成完毕！