Use this Knowledge Script to retrieve the number of active transactions that are ongoing, and the maximum number of transactions that can be executed concurrently (set as an initialization parameter). This script computes a ratio, expressed as a percentage, of the two numbers. When you enable data collection, the percentage is stored in the repository. You can set multiple thresholds for the maximum ratio, and the job raises an event when any of the thresholds exceeds the value you specified.
The account you use to run this script must have SELECT permissions for the following tables:
V_$PARAMETER
V_$TRANSACTION
V_$VERSION
Oracle Database folders. When you drop a script on an Oracle Database folder, a job executes on that database and collects the number of active transactions and the number of total transactions. The ratio of active transactions over total transactions is then computed.
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 the ratio of active transactions to maximum concurrent transactions? |
Set Yes to collect data for charts and reports. If data collection is enabled, returns the ratio of active transactions to maximum concurrent transactions as a percentage (%). The default is unselected. |
|
Raise event if ratio exceeds threshold? |
Select Yes to raise an event if the threshold exceeds the value you specified. The default is Yes. |
|
Threshold – ratio of active transactions to max concurrent transactions |
Specify a threshold for the maximum ratio of active transactions to maximum concurrent transactions, expressed as a percentage. The default is 95. |
|
Severity |
Set the event severity level, from 1 to 40, to indicate the importance of the event for successfully setting the monitoring options. The default is 5 (red event indicator). |
|
Raise event if ratio exceeds threshold? |
Select Yes to raise an event if the threshold exceeds the value you specified. The default is unselected. |
|
Threshold – ratio of active transactions to max concurrent transactions |
Specify a threshold for the maximum ratio of active transactions to maximum concurrent transactions, expressed as a percentage. The default is 80. |
|
Severity |
Set the event severity level, from 1 to 40, to indicate the importance of the event for successfully setting the monitoring options. The default is 15 (yellow event indicator). |
|
Raise event if ratio exceeds threshold? |
Select Yes to raise an event if the threshold exceeds the value you specified. The default is unselected. |
|
Threshold - ratio of active transactions to max concurrent transactions |
Specify a threshold for the maximum ratio of active transactions to maximum concurrent transactions, expressed as a percentage. The default is 60. |
|
Severity |
Set the event severity level, from 1 to 40, to indicate the importance of the event for successfully setting the monitoring options. The default is 25 (blue event indicator). |
|
Raise event if ratio exceeds threshold? |
Select Yes to raise an event if the threshold exceeds the value you specified. The default is unselected. |
|
Threshold - ratio of active transactions to max concurrent transactions |
Specify a threshold for the maximum ratio of active transactions to maximum concurrent transactions, expressed as a percentage. The default is 40. |
|
Severity |
Set the event severity level, from 1 to 40, to indicate the importance of the event for successfully setting the monitoring options. The default is 35 (magenta 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). |