enq: TX - row lock contention [message #320725] |
Fri, 16 May 2008 01:46 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
chara
Messages: 81 Registered: April 2005 Location: th
|
Member |
|
|
Hi all,
I have an example coding in my application as below :
select run_num from runnuma where parm1 = :param for update;
update runnuma set run_num = run_num + 1 where parm1 = :param ;
commit;
But i got row lock contention waiting around 30 mins. There are 300 rows of runnuma .
What happended? Does my logic or coding wrong?
Can anybody advise me?
PS: Oracle 10gr2 on solaris10
Thanks for advance
Chara
|
|
|
|
|
|