ODSEE - How to Configure and Monitor the 'db-locks' Configuration (Doc ID 2789203.1)

Last updated on MAY 04, 2023

Applies to:

Goal

The db-configured-locks attribute is the monitoring attribute for the db-locks configuration.

The db-configured-locks monitoring attribute is in the entry -
cn=database, cn=monitor, cn=ldbm database, cn=plugins, cn=config

The db-locks configuration attribute is by default 20k, and is in stored in the entry -
cn=config,cn=ldbm database,cn=plugins,cn=config

Reference: nsslapd-db-locks man page

The default configuration of 20k should be enough, but when this error is logged (in the ODSEE errors log) -

libdb: Lock table is out of available lock entries

where operations can fail with "err=1" in the access log, testing should be done in a non-Production environment to incrementally increase the db-locks configuration.

This KM doc goes over how to configure db-locks, verify the configuration of db-locks using db-configured-locks, and use db-max-locks to verify the error.

According to the dse.ldif man page -

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.