The following figure illustrates a monitor window. Only the left-most columns are displayed. To view additional columns, you need to scroll the column list to the right.
Figure 10 - 2. A Monitor Window
By default, the statistics are sorted on the first column. You can sort a statistics list on another column by clicking that column heading. A column name appears in bold to indicate that the statistics list is sorted on that column.
A few monitors contain columns on which you cannot sort the statistics list. When you click the column heading for one of these columns, the statistics list is not sorted again.
Note: When you click a column heading to sort on that column, a new sample is automatically taken.
The following figure illustrates setting the sampling interval.
Figure 10 - 3. Setting the Sampling Interval
The Interval pop-up menu contains several predefined sampling intervals that you can select from. You can also specify a different interval by choosing Other from the Interval pop-up menu.
When you choose Other, the Other Interval dialog box appears. The following figure illustrates the Other Interval dialog box.
Figure 10 - 4. Other Interval Dialog Box
In the Other Interval dialog box, you can specify a sampling interval in minutes and seconds. The minimum sampling interval is 15 seconds. The maximum is 100 minutes and 39 seconds, which you can express as 99 minutes and 99 seconds in the Other Interval dialog box.
When sampling cyclically, clicking the Hold button allows you to suspend sampling. The Hold button is replaced with a Resume button and the current statistics are not refreshed. To resume sampling, click Resume.
To sample statistics on demand, click Sample on Demand. The Hold button is replaced by a Sample button. Click Sample each time you want to sample statistics. The following figure illustrates sampling on demand.
Figure 10 - 5. Sampling on Demand
For non-numeric filters, you may use the SQL wildcard characters underscore (_) and percent sign (%). An underscore represents a single character; a percent sign represents any number of characters. A percent sign is implicitly added to the end of a filter text string.
Figure 10 - 6. Using Filters in a Monitor
In the filtering example in Figure 10 - 6, note that the percent sign wildcard character is used in the Statement filter. Statistics are displayed only for statements that contain the text string "privilege".
When there is more than one filter field, the filters are AND-ed together. That is, only statistics that match all the filters are displayed.
By default, the filter text entry fields are empty. If a filter text entry field is empty, then all values match that filter.