Field values

Data source

Each field contains a value obtained from a Performance Management product or program being monitored or the value derived there from by means of applying a formula. In the tables, the Data source column indicates the source of the value or the formula used to produce the value.

When a field's value is obtained by processing performance data acquired from Oracle, the character string in the Data source column indicates the method used to obtain the value that is set in the field. The following shows examples:

• When uppercase letters are shown:

  Uppercase letters indicate the table name of the Oracle Database when an Oracle Database is accessed. For example, the Cursor Open Hits (CURSOR_OPEN_HITS) field of the Activity Summary (PD_PDAS) record stores the value that is collected using OCI of Oracle. For details, see your Oracle documentation.

• When lowercase letters are shown:

  Lowercase letters indicate the key character string used to acquire the performance data that is stored in the Oracle Database table.

  For example, the Calls/Tran (CALLS_PER_TRANSACTION) field of the System Stat Summary (PD) record stores the value that is obtained by dividing the value obtained from user calls in the Name column of the V$SYSSTAT table by the value obtained from user commits in the Name column of the V$SYSSTAT table.

• When Remote Monitor Collector is shown:

  Remote Monitor Collector means that the value stored in the field was obtained from the Remote Monitor Collector service.

• When init.ora parameter name is shown:

  init.ora parameter name means that the value of the parameter name that is set in the init.ora Oracle initialization parameter file is used.

• When two dashes (--) are shown:

  Two dashes (--) means that the field's value is obtained without processing performance data.

To Page Top

Delta

In contrast to the data collected as the cumulative value, the so-called delta is the data that indicates the changed amount. For example, if the performance data value obtained during the first collection is 3 and the performance data value obtained during the second collection is 4, then the cumulative value is 7 and the changed amount is 1. In the tables, the Delta column indicates whether or not each field's value is a delta value. Note that since delta values are relative to previous data, they may be negative.

The following table explains the delta characteristics of performance data collected by PFM - RM for Oracle:

Table 5‒6: Performance data collected by PFM - RM for Oracle

Record type	Delta	Data type	Indicate delta value#	Record value
PI record type	Yes	Real-time data	Selected	The displayed value is the changed amount.
			Not selected	The displayed value is the changed amount.
		- Historical data - Alarm monitoring data	N/A	The displayed value is the changed amount.
	No	Real-time data	Selected	The displayed value was the actual value at the time of data collection.
			Not selected	The displayed value was the actual value at the time of data collection.
		- Historical data - Alarm monitoring data	N/A	The displayed value was the actual value at the time of data collection.
PD record type	Yes	Real-time data	Selected	The displayed value is the change.
			Not selected	The displayed value is the cumulative value.
		- Historical data - Alarm monitoring data	N/A	The displayed value is the cumulative value.
	No	Real-time data	Selected	The displayed value was the actual value at the time of data collection.
			Not selected	The displayed value was the actual value at the time of data collection.
		- Historical data - Alarm monitoring data	N/A	The displayed value was the actual value at the time of data collection.

Legend:

N/A: Not applicable

#

Indicates that the following check boxes are selected in the PFM - Web Console dialog box:

• Indicate delta value check box in the Report Wizard - Indication settings (Realtime) dialog box

• Indicate delta value check box in Indication settings (Realtime) on the Properties page of the Report window

The following points should be noted about collection of performance data:

• In order for a record of the PI record type to be saved, the performance data must be collected at least twice.

  For a record of the PI record type, performance data is collected at the interval set by PFM - Web Console. However, the performance data is not stored in the Store database when its collection is set by PFM - Web Console.

  Historical data for records of the PI record type requires two data collections in order to obtain the value (called delta) resulting from calculating the difference between two sets of data. Therefore, it takes up to twice as much time as the specified value before the historical data is stored in the Store database.

  For example, if PFM - Web Console sets the performance data collection interval at 300 seconds (5 minutes) at 18:32, the first data collection will begin at 18:35. The next data collection will begin at 18:40. Historical data is created from the data collected at 18:35 and 18:40, and is stored in the Store database as historical data at 18:40 (8 minutes after the time you entered the settings).

• In a real-time report, the value that is displayed is since the time the first data was collected. However, in reports requiring comparison with previous data, the initial values are shown as zero. Starting with the second cycle, the collection behavior depends on the type of report.

• The value of the collected data is displayed after the second data collection in the following cases:

  • The Indicate delta value check box is selected in the settings for real-time reports based on PI records.

  • The Indicate delta value check box is selected in the settings for real-time reports based on PD records.

• If the following setting is made, the difference between the first and second data collections is displayed at the second data collection; for the third and subsequent data collections, the value of the collected data is displayed when:

  • The Indicate delta value check box is selected in the settings for real-time reports based on PI records.

• While PFM - RM for Oracle is running, if a monitored instance of Oracle is restarted, or a resource is reallocated while Oracle is running, the value of collected data may be negative. Note that for data for the second and subsequent collections, positive values are used as the data differential.

• When a record of the PI record type is displayed in a real-time report, the first time collection data of the field where the delta field is Yes is invalid.

To Page Top