Shulou(Shulou.com)06/01 Report--

At present, a considerable number of companies will use oracle, so it is very important to monitor the database when doing performance testing, so here is how to generate the awr monitoring report that comes with oracle, and the content analysis of the specific report will be placed in the follow-up blog.

When you encounter the performance problems of the oracle database in the introductory study of oracle performance analysis, the first step is to export the AWR analysis report. The awr report is a monitoring report that comes with oracle, which will bring a lot of monitoring data. Then this blog introduces how to export the awr report.

1. First, you need to enter the oracle user. The linux command: su oracle, you can see the change from root user to oracle user.

two。 Then go to the sql command line

Sqlplus / as sysdba

3. You can reconnect, or test again.

Conn / as sysdba

4. Enter the oracle reporting options

@? / rdbms/admin/awrrpt.sql

5.Enter value for report_type: this display means to print the format in which a report is printed. Enter either html or text. If you enter enter directly by default, this is html.

Here, enter directly by default, that is, directly adopt the default html.

6.Enter value for num_days: the hint here is for us to output the report for a few days. If we write 1, we will output 1 day. If 2 is two days, we will output 1 day.

7.Enter value for begin_snap: the snapshot ID at the beginning of entry and exit, which refers to the printed snap id, followed by the start time of snap started

Enter a starting snapshot and output an ending snapshot id (where the starting id bit is 3739 and the ending id bit is 3740, that is, from 22:30 to 22:40, with an interval of 10 minutes), so that the oracle report for the two time periods is output

(general usage: in performance testing, first take a snapshot manually, or lower the time of the automatic snapshot, then execute the stress test script, and then take the snapshot id before and after the pressure test, so that you can export the results during the pressure test)

8.Enter value for report_name: enter the name of a report

For example, if test.html is not entered, it is the default.

9. Press exit to exit command line mode again, and a directory report can be generated under this directory.

Download this html and open it with a browser to see the awr test report!

Isn't it easy? let's try it first.

The above is the whole content of this article, I hope it will be helpful to your study, and I also hope that you will support it.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.