Oracle generates an AWR report and oracle generates an awr report.

Oracle generates an AWR report and oracle generates an awr report.

 Original Works are from the blog of "Deep Blue blog". You are welcome to reprint them. Please note the following source when reprinting them. Otherwise, you will be held legally liable for copyright.

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

Lab environment:

Operating System: win7 flagship edition 64bit

Database: oracle 11G R2 64bit

 

Step 2: log on 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 1: Set report collection conditions

Set to generate the record a few days ago. If set to 1, it will start from today. If set to 2, it will start from yesterday. The default value is 7. Next, use the default value and press enter to next.

Set the start id of the snapshot as follows:

Note: You can name AWR by yourself. Use the default value as follows and press Enter.

For example, the AWR report is generated successfully.

Find the AWR report in the specified path (generally, the report is stored in the System user directory by default.

 

Now, the introduction to generating the AWR report is complete (the methods are the same in LINUX ).

 

 Original Works are from the blog of "Deep Blue blog". You are welcome to reprint them. Please note the following source when reprinting them. Otherwise, you will be held legally liable for copyright.

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