mon_lw_thresh - Monitoring lock wait threshold configuration parameter
This parameter controls the amount of time spent in lock wait before an event for mon_lockwait is generated.
- Configuration type
- Parameter type
- Configurable online
- Default [range]
- 5000000 [1000 ... MAX_INT]
- Upgrade Note
- On databases created before 9.7 and then upgraded to 9.7 or higher, the mon_lw_thresh parameter is set to 4294967295 by default.
- Unit of measure
When this parameter is set both at the database level and at the workload level, the shorter of the two configured times is considered for the given workload.