Return
-
Title
Long Running Session Alarm for Oracle and SQL Server -
Description
Beginning with the 5.9.7.10 database cartridges, a long running session alarm has been included for SQL Server and Oracle agents.The alarms are named- DBO - Long Running Session (for Oracle)
- DBSS - Long Running Session (for SQL Server)
-
Resolution
The database agent must be configured to be running with SQL PI enabled.An alarm is fired for each session in which is threshold that is set in the alarm is exceeded.In some situations both a “Long Running Session” and “Long Lock Session” alarm may be fired at the same time for the same session.
The following video provides more information on the Long Running Session alarm
-
Defect ID
FOM-6