3.48 UserRollbackRatio

Use this Knowledge Script to monitor the user rollback ratio for an Oracle RDBMS Database. The user rollback ratio indicates the percentage of attempted application transactions that fail. The ratio compares the number of transactions rolled back to the total number of transactions attempted.

Because rolling back a transaction uses significant system resources, an increase in this ratio suggests resources have been wasted in attempting to execute failed transactions. If you see a continued increase in this ratio, it might indicate serious application or database performance problems. This script raises an event when the rollback ratio exceeds the threshold.

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

V_$SYSSTAT
V_$VERSION

3.48.1 Resource Objects

Oracle Database folders. When you drop a script on an Oracle Database folder, a job executes on that database and monitors only that database.

3.48.2 Default Schedule

The default interval for this script is Every hour.

3.48.3 Setting Parameter Values

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 user rollback ratio?

Select Yes to collect data for charts and reports. When you enable data collection, the Knowledge Script returns the current user rollback ratio.The default is unselected.

Raise event if threshold is exceeded?

Select Yes to raise an event if the number of user transaction rollbacks exceeds the threshold. The default is Yes.

Threshold - Maximum user rollback ratio

Enter a threshold for the maximum percentage of transaction rollbacks allowed before the job raises an event. The default is 75.

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).