Sun Java System Application Server Enterprise Edition 8.1 2005Q2 Performance Tuning Guide

- Previous: Summary
- Next: Timeouts

#### Tuning NumberOfLocks

Start with the default value. Look for exceptions with the indicated error codes in the Application Server log files. Remember that under normal operations (no ongoing refragmentation) only half of the locks might be acquired by the client application.

To get information on allocated locks and locks in use, use the following command:

`hadbm resourceinfo --locks`

For example, the output displayed by this command might look something like this:

    Node No.     Avail             Free            Waits
    0            50000             50000           na
    1            50000             50000           na

- Avail: Number of locks available.

- Free: Number of locks in use.

- Waits: Number of transactions that have waited for a lock.“na” (not applicable) if all locks are available.

  To change the number of locks, use the following command:

      hadbm set NumberOfLocks

  The `hadbm` restarts all the nodes, one by one, for the change to take effect. For more information on using this command, see Configuring HADB in Sun Java System Application Server Enterprise Edition 8.1 2005Q2 High Availability Administration Guide.

- Previous: Summary
- Next: Timeouts

- © 2010, Oracle Corporation and/or its affiliates