ODSEE - Monitoring Database Performance by Querying the "cn=database, cn=monitor, cn=ldbm Database, cn=plugins, cn=config" Entry (Doc ID 1616837.1)

Last updated on AUGUST 21, 2023

Applies to:

Goal

What type of information can be monitored by querying the cn=database, cn=monitor, cn=ldbm database, cn=plugins, cn=config entry?

For example -

./ldapsearch -h <HOSTNAME> -p <LDAP_PORT> -D "cn=<DS_ADMIN>" -w - -b "cn=database, cn=monitor, cn=ldbm database, cn=plugins, cn=config" "objectclass=*"

---------------------------------------------------------------------------------------------------------
dn: cn=database, cn=monitor, cn=ldbm database, cn=plugins, cn=config
objectClass: top
objectClass: extensibleObject
cn: database
nsslapd-db-abort-rate: 9115
nsslapd-db-configured-txns: 210
nsslapd-db-active-txns: 0
nsslapd-db-max-txns: 12
nsslapd-db-cache-hit: 2995569277
nsslapd-db-cache-try: 2996499618
nsslapd-db-cache-region-wait-rate: 243
nsslapd-db-cache-size-bytes: 2843738112
nsslapd-db-clean-pages: 992979
nsslapd-db-commit-rate: 177583474
nsslapd-db-deadlock-rate: 9115
nsslapd-db-dirty-pages: 6
nsslapd-db-hash-buckets: 1572836
nsslapd-db-hash-elements-examine-rate: 2034184923
nsslapd-db-hash-search-rate: 2998017086
nsslapd-db-lock-conflicts: 14921444
nsslapd-db-lock-region-wait-rate: 0
nsslapd-db-lock-request-rate: 4288826206
nsslapd-db-lockers: 481
nsslapd-db-configured-locks: 20000
nsslapd-db-current-locks: 87
nsslapd-db-max-locks: 3567
nsslapd-db-log-bytes-since-checkpoint: 262664
nsslapd-db-log-region-wait-rate: 19057
nsslapd-db-log-write-rate: 1186288944
nsslapd-db-log-write-count: 1781850
nsslapd-db-log-write-count-fill: 281956
nsslapd-db-log-flush-count: 1507077
nsslapd-db-log-flush-commit: 1507077
nsslapd-db-log-max-commit-per-flush: 0
nsslapd-db-log-min-commit-per-flush: 0
nsslapd-db-longest-chain-length: 13
nsslapd-db-page-create-rate: 247103
nsslapd-db-page-read-rate: 930303
nsslapd-db-page-ro-evict-rate: 0
nsslapd-db-page-rw-evict-rate: 0
nsslapd-db-page-trickle-rate: 0
nsslapd-db-page-write-rate: 58362584
nsslapd-db-pages-in-use: 992985
nsslapd-db-txn-region-wait-rate: 69631
---------------------------------------------------------------------------------------------------------

 

Solution

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