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
- Database
- 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
- Microseconds
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.