Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Long Waits
Hi all,
I am a programmer. One of our application inserts data into a table which is updated concurrently by other users. Both users will be working simultaneously but on different set of rows. In recent times, the insertion process waits till the updation completes and the users close their sessions. If i kill all the sessions and start the insertion it completes very quickly. Please give me the suggestions on how to aviod this long waits. We are using Oracle 7.3 on Windows NT.
Thanks in advance. Received on Tue Aug 08 2000 - 00:16:21 CDT