11/16/2023 0 Comments Spike performance and tuning![]() If you discover a performance problem, then you can attempt to resolve it in real time. In the example shown in Figure 4-3, the 5 -minute interval from 5:03 to 5:08 is selected for the CPU Used wait class. The information contained in the Detail for Selected 5 Minute Interval section is automatically updated to display the selected time period. To change the selected time interval, move the slider below the chart to a different interval. ![]() You can view the details of wait classes in different dimensions by proceeding to one of the following sections: Details for each wait class are shown in 5-minute intervals under Detail for Selected 5 Minute Interval. The Active Sessions Working page shows a 1-hour timeline. If you click a different wait class, such as User I/O, then the Active Sessions Waiting page appears.ĭescription of "Figure 4-3 Active Sessions Working page" If you click CPU Used, then the Active Sessions Working page for the wait class appears. The corresponding wait class is highlighted in the chart legend.Ĭlick the largest block of color on the chart or its corresponding wait class in the legend to drill down to the wait class with the most active sessions. To identify each wait class, move your cursor over the block in the Average Active Sessions chart corresponding to the class. appears in dark green and corresponds to the CPU Used wait class. In the chart shown in Figure 4-2, the largest amount of activity after 3:35 p.m. Values that use a larger block of active sessions represent bottlenecks caused by a particular wait class, as indicated by the corresponding color in the legend. ![]() ![]() The wait classes show how much database activity is consumed by waiting for a resource such as disk I/O. When the CPU Used value reaches the Maximum CPU line, the database instance is consuming 100 percent of CPU time on the host system. The Maximum CPU equals the number of CPUs on the system. 8 for CPU would mean that the session consumed CPU in 4 of 5 sampled seconds around the target time. For example, if only one session were active, then the value. Locate any sudden increases in the Average Active Sessions chart.Įach component shows the average number of active sessions in the specified state for the specified time. This chapter contains the following sections:ĭetermining the Cause of Spikes in Database ActivityĬustomizing the Database Performance Pageĭescription of "Figure 4-2 Monitoring User Activity"īy following the performance method explained in Chapter 2, "Oracle Database Performance Method", you can drill down from the charts to identify the causes of instance-related performance issues and resolve them.įrom the Database Home page, click Performance. To learn how to run ADDM manually, see "Manually Running ADDM to Analyze Current Database Performance". If you find a problem, then you can run ADDM manually to analyze it immediately without having to wait until the next ADDM analysis. However, if you notice a sudden spike in database activity on the Performance page, then you may want to investigate the incident before the next ADDM analysis.īy drilling down to other pages from the Performance page, you can identify database performance problems in real time. For example, ADDM performs its analysis after each Automatic Workload Repository (AWR) snapshot, which by default is once every hour. In some cases, you may want to monitor the database performance in real time to identify performance problems as they occur. Typically, you should use the automatic diagnostic feature of Automatic Database Diagnostic Monitor (ADDM) to identify performance problems with the database, as described in Chapter 3, "Automatic Database Performance Monitoring". Description of "Figure 4-1 Performance Page"
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |