We usually need to view multiple awr reports during O & M. If there are many reports, it will be very troublesome for us to make a copy. There is also a troublesome factor. Generally, our rac has multiple nodes. Then we have to open one copy of other nodes. This greatly reduces the efficiency of viewing problems. Although
We usually need to view multiple awr reports during O & M. If there are many reports, it will be very troublesome for us to make a copy. There is also a troublesome factor. Generally, our rac has multiple nodes. Then we have to open one copy of other nodes. This greatly reduces the efficiency of viewing problems. Although
We usually need to view multiple awr reports during O & M. If there are many reports, it will be very troublesome for us to make a copy. There is also a troublesome factor. Generally, our rac has multiple nodes. Then we have to open one copy of other nodes. This greatly reduces the efficiency of viewing problems. Although some monitoring software can quickly browse the load of a database every day, it is not used much after all. So I wrote an Excel macro to help analyze the waiting events in multiple AWR reports. Of course, topsql, cpu load, and I/o load will be released in the future. The script is as follows:
Awr_topevent. SQL
This script can be used to obtain the historical data of the awr Report of the top 5 events, and generate the following results using an excel macro, as shown in:
Exce program file download: generate a pie chart
Do O & M personnel seem convenient?
Original article address: Excel analysis tool-awr top 5 waiting event. Thank you for sharing it.