Use this Knowledge Script to monitor the transaction rate for an Oracle database. This script tracks the number of transactions per second to provide a basic measurement of application workload. In addition, this script raises an event if the number of transactions per second exceeds the threshold you set.
Changes to your applications or to application usage patterns can affect the transaction rate, but in general, an increase in the transaction rate suggests an increase in overall server load. If you see a decrease in the transaction rate with the same number of connected users, it can indicate that you need to do some database tuning or investigate the reasons for the changes.
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 30 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 transaction rate? |
Select Yes to collect data for charts and reports. When you enable data collection, the Knowledge Script returns the current transaction rate (transactions/second).The default is unselected. |
|
Raise event if threshold is exceeded? |
Select Yes to raise an event if the transaction rate exceeds the threshold you set. The default is Yes. |
|
Threshold - Maximum transaction rate |
Enter a threshold for the maximum number of transactions per second allowed before an event is raised. The default is 1. |
|
Severity |
Set the event severity level, from 1 to 40, to indicate the importance of the event. The default is 10 (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). |