Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Diagnosing Transaction Enqueue (TX) Locking Issue
We have an inhouse replication process which is causing us headaches
when we try to run more than one copy of it against the same target
database (we support unlimited remote databases so we may have to
process in 20 replication files on a Monday morning).
The issue I'm seeing is that computer 1 starts processing in the inserts/updates and continues through the process.
Computer 2 starts processing inserts/updates fine as well but at some point gets blocked by computer 1.
The lock is a TX lock and I'm trying to understand what could cause it.
Any help would be appreciated.
Tim Callaghan Received on Thu Sep 11 2003 - 14:53:21 CDT