Understanding Activity Significance

The Performance Analysis Resource Breakdown timeline provides you with a powerful and intuitive tool to rapidly isolate offending resource utilization, relative to entire instance and category totals. Use the Activity Timeline Scaling Options configuration in the Display Options History tab to focus the display:

• Select the Scale graph to instance check box if you want the display to retain the instance vertical scaling. Thus, any drilldown activity display is proportional to the total instance activity, granting you an immediate sense of its significance. You can manually refocus by using the vertical magnifier to the right of the timeline display.

If cleared, the display scale is that of the dimension subset of which the present drilldown is a part. (For example, the vertical scale could be a specific SQL statement and the activity representation, that of a specific database users portion within it.)  

• Select the Focus on target activity checkbox if you want the view to automatically refocus as you drill down within dimensions. You can manually refocus by using the vertical magnifier to the right of the timeline display.

If cleared, the scale reverts to that of the instance (if selected, as above) or that of the dimension in which this drill down is a part.

• Select the Show total in graph check box to display a dotted line representing total instance activity (if selected, as above) or that of the dimension in which this drill down is a part.