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.