Oracle generates AWR reports

Original works, from the "Blue Blog" blog, Welcome to reprint, please be sure to indicate the following sources, otherwise, the legal responsibility to pursue copyright.

Deep Blue Blog:http://blog.csdn.net/huangyanlong/article/details/43971547

Lab Environment:

Operating system:Win7 flagship version 64bit

Database:Oracle 11G R2 64bit

Step 1 : Login to sqlplus

C:\users\administrator>sqlplus/as SYSDBA

Step 2 : Run the script

Sql> @d:\soft\oracle\product\11.2.0\dbhome_1\rdbms\admin\awrrpt.sql

Step 3 : Set up report acquisition conditions

Set the record that was generated a few days ago, if set to 1, from today's xx: Start, if set to 2, from yesterday 00:00 , the default value is 7, Use the default values below to return to the next step.

Set the start IDof the snapshot as follows:

In particular, the name of the AWR can be self-named, if the default value, click Enter directly.

For example, theAWR report is generated successfully.

To the specified path (typically generated reports are stored by default in the System user directory) to find the AWR report to view.

At this point, the introduction of the Generate AWR report is complete (LINUX is the same method).

Original works, from the "Blue Blog" blog, Welcome to reprint, please be sure to indicate the following sources, otherwise, the legal responsibility to pursue copyright.

Deep Blue Blog:http://blog.csdn.net/huangyanlong/article/details/43971547

Oracle generates AWR reports