Concurrent access to a small table (10 rows)
Hi,
I have to find a solution to the following:
we have a small table
t1(ref varchar2(3), nb number);
the table has 10 rows
example:
'AAA', 0
'BBB',0
'CCC',145215
'DDD',0
...
the problem is that we have an application that can't be modified ( The editor wan't hear about it) this application run 2 process p1 and p2 and
both processes are accessing the same table t1 and the same row which is 'CCC' in the example,
p1 and p2 run the same DML:
sql stuff ......
UPDATE T1 set nb=nb + 1 where ref = 'CCC';
sql stuff ......
COMMIT;
i am getting the a huge ROW lock contention
Elapsed Time (ms) 703.16
CPU Time (ms) 0.21
Any idea how to work aroud this.