Use this Knowledge Script to monitor the user sessions that are blocking other sessions and processes from accessing the Oracle Database. You can set a maximum threshold for the number of sessions that are allowed to block other sessions and processes. If the number of blocking sessions exceeds the threshold, the job raises an event.
The account you use to run this script must have SELECT permissions for the following tables:
V_$LOCK
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 number of blocking sessions? |
Select Yes to collect data for charts and reports. When you enable data collection, the Knowledge Script returns the number of blocking sessions per interval. The default is unselected. |
|
Raise event if threshold is exceeded? |
Select Yes to raise an event if the number of blocking sessions exceeds the threshold you set. The default is Yes. |
|
Threshold - Maximum number of blocking sessions |
Enter a threshold for the maximum number of user sessions allowed to block other user sessions and processes during the monitoring interval. The default is 10. |
|
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). |