INSERT & UPDATE -
04-21-2007
, 06:55 PM
Hi guys I seem to have a problem with my DB ORACLE 8.1. Since I'm having
problem with tables hanging I've made a test procedure that INSERTS A RECORD
in the DB and than UPDATES it in a loop (1000 times). All of this without
any commit, if I launch this procedure from two PCs, in the same exact
moment, one of the two sessions, gets locked, and it takes about 15/20
seconds to execute the procedure.
Note : I have tried this also on another DB and it is much faster. Again , I
have relaunched it in my DB, commiting the transaction , and it is executed
immediately.
What can the problem be, what do you guys think ? |