Oracle-awr Report Introduction and how to generate "go"

AWR report

The AWR report is a performance collection and analysis tool provided by Oracle 10g and above that provides a report of the overall system resource usage over a period of time, through which we can understand the entire operation of the Oracle database, such as the scale of the hard interpretation, the catch hit rate, etc. It's like a person's comprehensive medical report.

Generate AWR reports

1. Use the Sqlplus command to access DBA authority for the database

Sqlplus/as SYSDBA

2. Call the AWR report execution script

Sql>@?/rdbms/admin/awrrpt.sq

3. Enter the generated AWR report type as prompted to enter the HTML

Input: HTML

4. Enter the number of days to collect the AWR reports

From the time of the server day in fact, go back, enter 1, represent the display today 0 o'clock to the current time of monitoring

Input: 1

5. Enter the start Snap ID and end snap ID to be collected according to the list shown

Beigin_snap

According to the actual situation:

Type begin_snap:36

Type end_snap:51

6. Depending on the prompt, the name of the output file (ending in. html) is required

Type the report name of the generated awrrpt: 140_oracle_awr.html

At this point, the AWR report is generated in the current directory. Have a:

AWR report

AWR report

Oracle-awr Report Introduction and how to generate "go"