Overview

Performance Analysis for Oracle

previous page next page

Overview Tab

The Overview tab and feature is the primary history and real-time tool for initial understanding of the system resource use patterns that you see in the = 4) BSPSPopupOnMouseOver(event)" CLASS=BSSCPopup id=A1>activity timeline graph. The tool lets you view the performance-oriented metrics, time correlated with any activity drilldown. The middle pane timeline graphical representation and explanation displays respond to the choice of resource focus in the Resource/Metric list pane. ToolTip hints display any additional available information. The display is composed of the resource timeline and expert metrics (in accordance with the selected resource). 

The overview tool is a unified view of the entire range of activity projections: full instance, specific session, and any historical activity drilldown (for example, User JOHN executing a program on machine ATLAS).

The pane list metrics displayed in the window's lower third are determined by the chosen = 4) BSPSPopupOnMouseOver(event)" CLASS=BSSCPopup id=A3>Resource. The Resource chosen displays those metrics that have the greatest relevance and impact on that resource as it may affect throughput and response time. In turn, the chosen metric determines the text displayed in the middle third right side. For those metrics that can be represented as a percentage of a total, a horizontal bar presentation presents both its internal component portions (for example, in the Oracle/System CPU Usage, CPU consumption is composed of the instance background and foreground CPU and CPU used by all other processes) and their total.

The overview representation and values are determined by:

  • Dimension Navigation parameters

  • Metric Totalings - For ease of use and comparability, differing totaling methods can be applied. Select from among the possible methods in accordance with your summary needs:

  • Period Total (default) metric aggregation within one column for the entire time range

  • Rate (Per Interval) summarizes the data for averages and totals with periods defined by the Data Interval

  • Rate (Per Second)

  • Per Execution of SQL statements

Note: For methods that entail both averages and totals, the horizontal bar presentation and ToolTip display reflect the column in focus.

 

 

previous page start next page