Sun Java System Application Server Enterprise Edition 8.1 2005Q2 High Availability Administration Guide

- Previous: Data Buffer Pool Information
- Next: Log Buffer Information

### Lock Information

Lock information is as follows:

- `NodeNo`: Node Number.

- `Avail`: Total number of locks available on the node.

- `Free`: Number of free locks.

- `Waits`: Number of transactions waiting to acquire locks. This is cumulative.

One single transaction cannot use more than 25% of the available locks on a node. Therefore, transactions performing operations in large scale should be aware of this limitation. It is best to perform such transactions in batches, where each batch must be treated as a separate transaction, that is, each batch commits. This is needed because read operations running with `repeatable read` isolation level, and `delete`, `insert`, and `update` operations use locks that are released only after the transaction terminates.

To change the `NumberOfLocks`, see Clearing and Archiving History Files

##### Example 3–18 Example lock information

For example:

    NodeNO Avail Free Waits
    0 50000 20000 101 50000 20000 0

- Previous: Data Buffer Pool Information
- Next: Log Buffer Information

- © 2010, Oracle Corporation and/or its affiliates