Re: oracle deadlock error on insert

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Fri, 25 Jun 1999 16:49:30 +0100
Message-ID: <930326015.11153.1.nnrp-12.9e984b29@news.demon.co.uk>

It is possible that you are getting a deadlock on the ITL (interested transaction list).

Have you set INITRANS to 4 on all tables and indexes that you are writing to ?

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

paul.r.malcomson_at_ac.com wrote in message <7l06i8$6qs$1_at_nnrp1.deja.com>...
>Deadlock is detected on any of the threads. Usually 1 thread seems
>to 'take over' and process to completion and the other 3 threads fail
>with a deadlock. Oracle trace file indicates this is not an oracle
>error but poor code in the application.
>
>Oracle defines a deadlock as occuring only during an update process.
>There is no update being performed here. Auditing is performed into
>audit tables, so yes an updated IS performed (when a commit point is
>reached, update interval records processed), but the trace file does
>not mention the update to the audit table at all.
Received on Fri Jun 25 1999 - 10:49:30 CDT