Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Locks in Oracle 9i
Hi Guido,
> just to add a bit to what Daniel and Anurag
> wrote: if you forget to code a commit in your
> procedure, you can issue this statement manually
> after the proc's completion. And I'm very curious
Ok.
> to know what you do in your application that
> causes Oracle to lock a table where you don't
> *need* the lock. Could you please describe what happens?
My program does a lot of inserts, updates (>10.000) and some stored
procedure calls. Sometimes it just stops when trying to do an update,
because the table is locked. And when I kill the program the lock on
that table is still there.
But I can't reproduce this behavior at will and it didn't happen today.
So maybe I just did too many things at the same time like running the
program on the client and coding/testing new procedures on the host.
Greetings - Jan Received on Tue Sep 30 2003 - 11:37:55 CDT