On Tue, 30 Sep 2003 11:47:58 +0000 (UTC), Rajesh Punjabi wrote:

>...
> Alan Wrote :
>
>> Can both you guys make sure that your apps commit regularly? This moves
>> the transactions along.
>>
> In our case, all transactions are container managed and they do get
> closed. We monitered locks and memory and they all come back to zero
> after each request. The connections are all at a constant number because
> of Application server conneciton pooling.

Do you monitor through a tool with a transaction that stays open for a long
time? If you don't close the tx and open a new one you are keeping that
transaction open which is not a good thing. (I do assume you didn't
monitor until you observed problems, so I'm just asking to be sure)


--
Aage J.