The ADJUSTABLE LOCK GRANULARITY clause enables or disables
    adjustable locking granularity. Generally, enabling adjustable
    locking granularity results in fewer locks being used. However,
    when contention for database pages is high, performance may be
    impaired as locking granularity is adjusted to a lower level. If
    your application is query intensive, enable adjustable locking
    granularity. If your application processes specific records and
    performs a substantial number of update operations, you might
    want to disable adjustable locking granularity.

    Disabling adjustable locking granularity may require that the
    OpenVMS SYSGEN parameters for locks be increased.