Use this Knowledge Script to monitor statistics from a database’s f.$SYSSTAT table. 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.
The account you use to run this script must have SELECT permissions for the following tables:
V_$SYSSTAT
V_$VERSION
Oracle Database folders. When you drop a script on an Oracle Database folder, a job executes on that database and monitors only that database.
The default interval for this script is Every 10 minutes.
Set the following parameters as needed:
|
Description |
How to Set It |
|---|---|
|
Oracle Username |
Enter the username that this script needs to access the target databases. If you run this script on more than one database, configure each database with the same username. To use SYSDBA authentication, leave this parameter blank. The default is blank. |
|
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. The default is unselected. |
|
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 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. |
|
Raise event if threshold is exceeded? |
Select Yes to raise an event if the threshold you set is crossed. The default is unselected. |
|
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). |
|
Event severity for internal failure |
Set the event severity level, from 1 to 40, to indicate the importance of the event. The default is 5 (red event indicator). |