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

Home -> Community -> Usenet -> c.d.o.server -> Re: Blocking Question

Re: Blocking Question

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 19 Aug 2005 00:16:46 +0200
Message-ID: <h32ag1dl9ho44d7qvo0ta9fcmg53jfapii@4ax.com>


On Thu, 18 Aug 2005 21:50:20 GMT, "JD" <jd_at_hotmail.com> wrote:

>We have a puzzling situation where doing a series of Inserts will block. The
>user has a transaction consisting of 4 inserts then has to confirm and we
>commit. If a second user starts the same sequence, the 4th insert will block
>until the first user commits. Our database people felt that there was a
>problem with foreign keys and indexes. Googling turns up lots of info on
>this.
>
>So, after an unsuccessful series of tests designed to locate the offending
>key, they disabled all of the foreign keys. Still blocked. So here's the
>question -- What other things will cause an insert to block? These are all
>new rows being inserted and each user has a different set of rows. And there
>are some triggers on a row insert.
>
>TIA,
>
>Mike P
>

Did you actually look into v$lock by means of the Oracle provided scripts?
Did you actually check out by means of the verious v$%wait% views what your process is waiting for?

--
Sybrand Bakker, Senior Oracle DBA
Received on Thu Aug 18 2005 - 17:16:46 CDT

Original text of this message

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