Oracle Enterprise Manager Performance Monitoring User's Guide

Library

Product

Contents

Index

Defining or Modifying Charts

Defining a New Chart
Example of Defining a New Chart
Modifying the Basic Definition of a User-defined SQL Chart
Modifying the Basic Definition of a Predefined Chart

In addition to the wide variety of predefined charts and customizing features that Oracle Performance Manager provides, you can also define your own charts or modify the basic chart definition. This chapter covers the following topics:

Defining a New Chart
Example of Defining a New Chart
Modifying the Basic Definition of a User-Defined Chart
Modifying the Basic Definition of a Predefined Chart

Attention:

While this chapter covers how you modify the basic definition of a chart, such as the SQL statement used to gather the data the chart presents, or the mathematical operation performed on such data, Customizing Display Elements of Charts on page 4-1 covers how you customize specific display elements such as color scheme, size, and scale.

Defining a New Chart

You can define new SQL charts.

To define a new SQL chart, select New SQL Chart from the Charts menu.

The resulting New SQL Chart property sheet includes the following pages:

SQL Statement
Display Options

To select one of these pages, click on the appropriate tab title near the top of the New Chart property sheet. You can select the Display Options page only after you have completed the SQL Statement page.

SQL Statement Page

Use the SQL Statement page of the New SQL Chart property sheet to enter a SQL statement that will be used to gather statistics for the chart you are defining. For more information on SQL, see Oracle7 Server SQL Reference.

The SQL Statement page contains the following:

Display Options Page

Use the Display Options page of the New SQL Chart property sheet to customize how the resulting data from the SQL statement entered on the SQL Statement page will be displayed in chart form. The Display Options page contains the following:

Label

Enter text in this box to label a variable you are presenting as a column in your chart.

Simple

Click this button (default) to indicate that the chart will display a simple query against a table or view, or a calculation on a simple query against a table or view. A simple function f(a) contrasts with a complex function f(a) operation f(b), where operation is one of the operations of the Operations combo box.

Clicking the Simple button disables the Operations combo box and the second Function and second Column combo boxes of the Display Options page. File I/O Rate and virtually all of the other predefined charts are examples of simple charts.

Complex

Click this button to perform a more complex operation on two queried values from a table or view. A complex function takes the form f(a) operation f(b), where operation is one of the operations of the Operation combo box. This complex function contrasts with a simple function f(a), as selected using the Simple button.

Clicking on the Complex button enables the Operation and second Function and second Column combo boxes of the Display Options page. Buffer Cache Hit % and Library Cache Hit % are examples of complex predefined charts. (Almost all of the other predefined charts are simple.)

Function

Click this first Function combo box to select the type of function to be used on one or more retrieved values from a table or view.

The following function definitions refer to current and/or previous retrieved values. The current retrieved value is the value from the most recent data refresh. The previous retrieved value is the value from the data refresh previous to the most recent data refresh.

Options include: <none> (to display the current retrieved value without applying a function to it; this is the default); Delta (to display the current retrieved value minus the previous retrieved value); Normalize (to display the current retrieved value minus the retrieved value when the chart was first displayed); Pct of Total (to display the current retrieved value as a percentage of the sum of all values in the column); and Rate (Delta) (to display the value of Delta divided by the amount of time between the current and previous retrieved values).

Column

Click on this first Column combo box to select which variable will be represented in a column of the chart. This box contains column names from the result of the SQL statement you entered in the SQL Statement box.

Add

Click on this button to add the column(s) you have defined to the chart, and display these definitions in the Selections to Display box on this page.

Operation

Click on this second Operation combo box to select the operation to perform on two variables to produce data for a column in a complex chart.

Options include: + (addition); - (subtraction); * (multiplication); / (division); and / (* 100 %). This box is enabled only when the Complex button has been selected.

Function

Click on this second Function combo box to select the type of function to be used on the second operand to produce data for a column in a complex chart.

Options include: <none>, Delta, Normalize, Pct of Total, and Rate (Delta). See the section describing the first Function combo box of the Display Options page for definitions of these functions. This second Function combo box is enabled only when the Complex button has been selected.

Column

Click on this second Column combo box to select the second variable on which the operation is to be performed to produce data for a column in a complex chart. This second Column combo box is enabled only when the Complex button has been selected.

Selections to Display

This box displays the label/function mapping defined for each columnname of the chart.

Delete

Click on this button to delete the selected column from the Selections to Display box. The chart you are defining will not display the column you have just removed.

Clear All

Clears all entries in the Selections to Display field, so that you can enter a new label/function mapping for each columnname of the chart.

Row Label

Click on this combo box to specify a column from which data will be used to label the rows of the chart. The default is <none>.

Chart Type

Click on this combo box to select the chart type for the chart you are defining.

Options include: TABLE (default), AREA, BAR, CUBE, HORIZONTAL BAR, LINE, and PIE. If you have chosen to display non-numeric (string) data in the chart, you must select the TABLE chart type. For more information on these chart types, see Chart Types on page 2-9.

Transpose Chart Axes

Click on the No button (default) of this button group to accept the default mapping of variables in your SQL statement as columns in the chart.

Click on the Yes button of this button group to map the variables in your SQL statement as rows in the chart.

Apply

Disabled.

OK

Click on this button to apply the chart definitions you have specified on pages of the New SQL Chart property sheet, exit the property sheet, and display the new chart you have just defined. (If you then want to modify the chart, choose Modify SQL Chart from the Charts menu.)

Cancel

Click on this button to cancel the chart definitions you have specified on both pages of the New SQL Chart property sheet and exit the property sheet.

Example of Defining a New Chart

This section illustrates how you would define a simple chart with two additional features: transposed axes and drilldown capability. This section explains the steps you would take if you were to define a chart similar to the predefined chart File I/O Rate.

Figure 5-1 shows the SQL Statement page of the New Chart property sheet, completed as if one were to define the File I/O Rate chart from scratch.

Figure 5-1: SQL Statement Page for a New Chart

As Figure 5-1 suggests, to define this chart you would complete the SQL Statement page as follows:

1.: Enter a unique name for the new chart.
2.: From the Drilldown Window combo box, select the drilldown option (chart window or Oracle TopSessions option) that will appear when the user drills down from the chart you are defining.
: In Figure 5-1, the drilldown option TOPSESSIONS - FILE I/O has been selected. Thus, when the chart user drills down from the chart you are defining, Oracle TopSessions will be launched, and the Oracle TopSessions main window will display the top 10 sessions sorted according to level of file I/O activity.
3.: In the SQL Statement box, enter the SQL statement used to gather the statistics the chart will display.
4.: Click on the Execute button to execute this SQL statement and display the result in the Result box.
5.: In the Result box, verify that the SQL statement produces the results you want.
: (If an error message were displayed in the title bar of the Result box, you would reenter the SQL statement in the SQL Statement box and click on the Execute button again until you had obtained the results you wanted. If the message, "No Data Available," appeared in the title bar of the Result box, it would indicate that the SQL statement was correct but returned no data.)
6.: Click on the Display Options tab at the top of the property sheet.

Figure 5-2 shows the DIsplay Options page of the New Chart property sheet, completed as if one were to define the File I/O Rate chart from scratch.

Figure 5-2: Display Options Page for a New Chart

As Figure 5-2 suggests, to define this chart you would complete the Display Options page as follows:

1.: To clear the Selections to Display box of the default Label, Function and Column selections, click on the Clear All button.
2.: In the Label box, enter "Physical Reads/s" as the label for the first chart variable you are defining.
3.: Accept the default selection of the Simple button to define a simple chart.
4.: From the first Function combo box, select "Rate (Delta)," in order to show the rate of change of the variable (physical reads, in this case) over time.
5.: From the first Column combo box, select the first variable, "SUM(PHYRDS)," to correspond to the label you have specified.
6.: Click on the Add button to add this first label/function/column mapping to the Selections to Display box.

The above six steps have defined the first variable of the chart. The next five steps define the second variable of the chart.

7.: In the Label box, enter "Physical Writes/s" as the label for the second variable you are defining.
8.: Accept the default selection of the Simple button to define a simple chart.
9.: From the first Function combo box, select "Rate (Delta)" in order to show the rate of change of the variable (physical writes, in this case) over time.
10.: From the first Column combo box, select the second variable, "SUM(PHYWRTS)" to correspond to the label you have specified.
11.: Click on the Add button to add this second label/function/column mapping to the chart.

The next two steps specify display options for the chart as a whole.

12.: In the Chart Type combo box, click on "LINE" to define the chart format as a line chart.
13.: In the Transpose Chart Axes button group, check the Yes button, so that the two variables you have defined will be plotted as rows, rather than as columns, in the chart. (Plotting variables as columns is the default.)

The next steps complete the process of defining a new chart.

14.: Click the OK button to save the chart, exit the New Chart property sheet, and display the saved version of the new chart.
15.: Close the chart to return to the Oracle Performance Manager main window.

Figure 5-3 shows the chart created from these two pages of the New Chart property sheet, as completed in Figure 5-1 and Figure 5-2.

Figure 5-3: Example of a Simple Chart with Transposed Axes

Modifying the Basic Definition of a User-defined SQL Chart

To modify the basic definition of an existing user-defined SQL chart, it is best to display the chart, as described in Displaying Charts in Chart Windows on page 6-1, and then choose Modify SQL Chart from the Charts menu.

The resulting Modify SQL Chart property sheet is virtually identical to the New SQL Chart property sheet described in a previous section, "Defining a New Chart," but for the following exception:

Chart Name

On the Modify SQL Chart property sheet, Chart Name is a combo box from which you select the existing user-defined chart whose basic definition you want to modify.

Modifying the Basic Definition of a Predefined Chart

In the initial release of the Oracle Performance Manager, only user-defined charts can be modified using the Modify Chart property sheet, as described in the previous section. If you want to create a modified version of a predefined chart, you can perform the following steps:

1.: Display the predefined chart, as described in Displaying Charts in Chart Windows on page 6-1.
2.: In order to review its basic definition, choose Modify SQL Chart from the Charts menu.
3.: From the Chart Name combo box, select the name of the predefined chart.
4.: Take note of those definitions. For predefined charts, these definitions are greyed out and are displayed for informational purposes only.
5.: Define a new chart that is a modified version of the predefined chart, and assign it a unique name. For more information, see Defining a New Chart on page 5-1.

Prev Next

Library

Product

Contents

Index