![]() ![]() In the graph shown in Figure 4-2, the largest block of activity appears in green and corresponds to the CPU Used wait class as described in the legend. Values that use a larger block of active sessions represent bottlenecks caused a particular wait class, as indicated by the corresponding color in the legend. All other values in the graph represent users waiting and contention for resources, which are categorized by wait classes in the legend. ![]() When the CPU Used value (shown in green) reaches the Maximum CPU line (shown as a dotted red line), the database instance is running at 100 percent of CPU time on the host system. ![]() You can monitor database health and user activity using the Average Active Sessions graph. This chapter contains the following sections:ĭescription of "Figure 4-2 Monitoring User Activity" For more information about running ADDM manually to analyze performance in real time, see "Manually Running ADDM to Analyze Current Database Performance". If a performance problem is identified, you can choose to run ADDM manually to analyze it immediately, without having to wait until the next ADDM analysis. By drilling down to appropriate pages from the Database Performance page, you can identify performance problems with the database in real time. However, if you notice a sudden spike in database activity on the Database Performance page, you may want to investigate the incident before the next ADDM analysis. For example, ADDM performs its analysis after each AWR snapshot, which by default is once every hour. In some cases, however, you may want to monitor the database performance in real time to identify performance problems as they happen. Typically, you should use the automatic diagnostic feature of ADDM to identify performance problems with the database, as described in Chapter 3, "Automatic Database Performance Monitoring". Description of "Figure 4-1 Database Performance Page" ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |