4.10 SysStat

Use this Knowledge Script to monitor statistics of a database instance through the V.$SYSSTAT table of the database. This table stores all the key statistics for a database. You specify the statistic to monitor, and the value and condition (greater than, less than, or equal to) to check. If the value or change rate (changes per second) of a monitored statistic crosses a threshold, the job raises an event.

This Knowledge Script is supported on Oracle 11gR2 and Oracle 12c.

The account you use to run this script must have SELECT permissions for the following tables:

V_$SYSSTAT
V_$VERSION

4.10.1 Resource Objects

Oracle RAC Database Instance. When you drop a script on an Oracle RAC Database Instance, a job executes on that database instance and monitors the statistic specified from that instance.

4.10.2 Default Schedule

The default interval for this script is Every 10 minutes.

4.10.3 Setting Parameter Values

Set the following parameters as needed:

Description

How to Set It

General Settings

Cluster(s) to exclude

Enter the cluster names to exclude with a comma (,) between each cluster name, to exclude the cluster from all jobs.

Database Instance(s) to exclude

Enter the database instance names to exclude with a comma (,) between each database instance name, to exclude the database instance name from all jobs.

V_$SYSSTAT statistic to monitor

Enter the name of the statistic you want to monitor--for example, USER CALLS.

For information about the fields in the V_$SYSSTAT table, see your Oracle RDBMS documentation (for example, in the Oracle8 Reference, see “Appendix C: Statistics Descriptions”).

The default statistic is execute count.

Monitor change rate or value of statistic?

When you select Change rate, the script monitors the number of times the value of the monitored statistic changes per second. When you select Value, the script monitors the value of the statistic. The default is Change Rate.

Event severity when job fails

Set the event severity level, from 1 to 40, to indicate the importance of the event. The default is 5 (red event indicator).

Event detail format

Select one of the following formats in which to view all events:

  • HTML Table

  • Plain Text

The default is HTML Table.

Enable debugging?

Select Yes to enable debugging. The default is unselected.

Raise event when AppManager fails to get metrics?

Select Yes to raise an event when AppManager fails to get the metrics. The default is Yes.

Event severity when AppManager fails to get metrics

Set the event severity level, from 1 to 40, to indicate the importance of the event. The default is 5 (red event indicator).

Event Settings

Raise event if threshold is exceeded?

Select Yes to raise an event if the threshold you set is crossed. The default is Yes.

Condition: <, =, or >

Indicate the condition (less than, equal to, or greater than) you want to check. This parameter is used in conjunction with the Threshold - Change rate or value parameter to control when the job raises an event. The default is greater than (>).

Threshold - Change rate or value

Enter a threshold value or rate for the specified statistic. Depending on how you set the Monitor change rate or value of statistic? parameter, this might indicate a threshold for the value of the statistic or for the number of changes in that value per second. The value you set here is used in conjunction with the Condition: <, =, or > parameter to control when the job raises an event. The default is 100.

Severity

Set the event severity level, from 1 to 40, to indicate the importance of the event. The default is 5 (red event indicator).

Data collection options

Collect data for a V$SYSSTAT statistic?

Select Yes to collect data for charts and reports. When you enable data collection, the Knowledge Script returns the current value of the specified statistic at each interval from that database instance. The default is unselected.