Product Documentation

Database Administrator's Guide

Previous Topic

Next Topic


SNAPSHOT_LOCKWAIT_USEC <lock wait histogram interval width in microseconds>

Histograms of waiting times for blocked lock requests are available: one for waiting times for blocked data record lock requests, and one for waiting times for blocked index lock requests (please note that the index locks are not controlled by the user). There is a small amount of overhead associated with mutex calls to collect clean statistics.

SNAPSHOT_LOCKWAIT_USEC can change the default histogram intervals (box width) for the lock waiting time histograms (default of 10,000 µsec or 0.01 seconds).