Check out if the program do updates and commit all in one enter.
If the program updates some central table and then ask the user
to commit or rollback and he is out for a smoke then the rows will
stay locked until he returns.
Here we stress the importance of doing update+commit at once
without us
For the session that is hanging, can you query all of the enqueues for that
SID from V$LOCK?
The rows with type = 'TM' are "DML locks" against any tables or indexes
which are being modified by the session. For "TM" locks, the ID1 column in
V$LOCK contains the "DATA_OBJECT_ID" for the object bein
Anybody have any experience with Microsoft Txn Server? I am running into
issues with a few Windows2000 servers running Microsoft Txn Servers that are
connecting to my 8.1.7.4 HP-UX database. There are several concurrent txns
running that do a lot of inserting and data loading. Most of the time