The LatchMonitor monitors the database for excessive latch sleep activity. An alert is generated when latch sleep activity exceeds a configurable threshold.
The <LatchMonitorConfig> element is configured with the following attributes:
||The LatchMonitor examines only those latches for which the number of sleeps exceeds the value specified for SLEEP_THRESHOLD. The value provided for this attribute must be a positive integer.
||The LatchMonitor generates an alert when the sleep rate (100*sleeps/gets) exceeds the value specified by MAX_SLEEP_RATE for any latch having sleeps in excess of SLEEP_THRESHOLD. The value provided for this attribute must be a positive number.
||The MAX_SLEEP_RATE_CHANGE specifies the maximum allowed change in a latch sleep rate, from one task execution to the next, before an alert is generated.
In this example, TCAgent sends an alert when any latch with more than 1000 sleeps either has a sleep rate greather than 0.1, or has a sleep rate that has more than doubled (2x) from the prior task execution.