Re: Blocking Question

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