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

This article mainly introduces "how to generate AWR report". In daily operation, I believe many people have doubts about how to generate AWR report. The editor consulted all kinds of data and sorted out simple and easy-to-use operation methods. I hope it will be helpful to answer the doubts about "how to generate AWR report". Next, please follow the editor to study!

AWR report

Awr report is a performance collection and analysis tool provided by oracle 10g and above. It can provide a report on the use of system resources over a period of time. Through this report, we can understand the whole operation of Oracle database, such as hard explanation ratio, Catch hit rate, etc., which is like a person's comprehensive physical examination report.

AWR principle

After ‍‍ Oracle starts, there will be a process in the background to collect snapshot information of the system every hour. The source of information collection is: V$active_Session_History view. This view shows the history of the most recently active session. The collected information was preserved for 8 days. (query SQL:select * from dba_hist_wr_control;) sampling frequency and save time are configurable.

Snapshots are automatically taken at fixed intervals by the processes of MMON and MMNL.

Generate AWR report

1. Go to the Oracle installation directory and find awrrpt.sql

two。 Log in to sqlplus to execute awrrpt.sql

@ / oracle/app/oracle/product/19.0.0.0/db_1/rdbms/admin/awrrpt.sql

3. Enter report_type report type (html/txt) the commonly used report type is html

4.

5. Enter the minimum and maximum snap id, and try to select the snap id within the time range.

Enter value for begin_snap: start time Snap Id

Enter value for end_snap: end time Snap Id

6. Enter the name and path to generate the Oracle AWR (performance Analysis) report

Example: / oracle/20210203UTMS_AWR.html

7.

8. View AWR report

At this point, the study on "how to generate AWR report" is over. I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!

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.