Oracle AWR Performance Monitoring Report generation method

At present, a considerable part of the company will use Oracle, when doing performance testing, the database monitoring is very important, then here first describes how to generate Oracle's own AWR monitoring report, and the specific report content analysis will be placed in the subsequent blog

Oracle Performance Analysis Primer Learning, encountered the performance of Oracle database, the general first step is to export the AWR analysis report, the AWR report is the Oracle's own monitoring report, will bring a lot of monitoring data, then this blog is about how to export the AWR report

1. first need to access Oracle user, Linux command:su Oracle, you can see from the root user to Oracle user

2. then go in . SQL Command line

Sqlplus/as SYSDBA

3. You can connect again, or test again

Conn/as SYSDBA

4. Enter Oracle reporting Options

@?/rdbms/admin/awrrpt.sql

5.Enter value for Report_type: This display means printing a report in what format, either entering HTMLortyping text, If the direct default carriage return, here is the HTML

This is the direct default return, which is directly using the default HTML

6.Enter value for Num_days: Here's the hint is let us output a few days of the report, if write 1 on the output 1 days, if 2 just two days .

7.Enter value for Begin_snap: The snapshot IDof the entry and exit, which refers to theprinted snap ID, followed by Snap started start of Time

Enter a snapshot of the start, output an end of the snapshot ID (the start ID bit 3739, end ID bit 3740, that is, from 22:30-22:40, 10 minutes between the interval), so that the two time period of the Oracle Report Output

(General usage, performance test, first take a snapshot manually, or reduce the time of the automatic snapshot, and then perform a pressure test script, and then manually shoot the same, before and after the compression measurement of the snapshot ID, so that the results can be exported during the pressure test)

8.Enter value for Report_name: Enter the name of a report

such as test.html, not input is the default

9. Press exit to exit the command line mode to generate a directory report in this directory

Download this HTML and open it with your browser to see the awr test Report!

is not very simple, first try it ~ ~ ~

Oracle AWR Performance Monitoring Report generation method