Sun Java System Application Server Enterprise Edition 8.1 2005Q2 Troubleshooting Guide

- Previous: Is the node-internal Log Full?
- Next: Solution 2: Increase the number of locks

### Solution 1: Split Long Transactions

A transaction running on a node is not allowed to use more than 25% of the number of locks allocated on that node. Read transactions running at the “repeatable read” isolation level and the update/insert/delete transactions hold the locks until the transaction terminates. Therefore, it is recommended to split long transactions into small batch of separate transactions.

- Previous: Is the node-internal Log Full?
- Next: Solution 2: Increase the number of locks

- © 2010, Oracle Corporation and/or its affiliates