Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Locks in Oracle 9i

Re: Locks in Oracle 9i

From: Jan Pompe <jan.pompe_at_gmx.de>
Date: Tue, 30 Sep 2003 18:37:55 +0200
Message-ID: <blcbhn$ak73f$1@ID-137428.news.uni-berlin.de>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US