Database Reference
In-Depth Information
Figure 4-6. Activity chart showing the top 10 SQL statements for the time period selected in Figure 4-5
top consumer table shows, for the selected dimension, the top consumers along with their average
number of active sessions over the selected period of time. Note that you can select a dimension
different from the one you select for the activity chart. For example, Figure 4-7 shows what the SQL
statements are that spent most of the DB time for the 5-minute period selected in Figure 4-5 . Notice
that by hovering over the activity bar with the pointer, you can also get some information about the
kind of activity performed by the SQL statement. For instance, in Figure 4-7 , the top SQL statement
spent 29% of the time waiting on events associated to the User I/O wait class.
A
Figure 4-7. Top consumer table showing the top 10 SQL statements for the time period selected in Figure 4-5
 
Search WWH ::




Custom Search