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: oracle deadlock error on insert

Re: oracle deadlock error on insert

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Fri, 25 Jun 1999 16:53:35 GMT
Message-ID: <3773b3f2.80723223@newshost.us.oracle.com>


A copy of this was sent to paul.r.malcomson_at_ac.com (if that email address didn't require changing) On Fri, 25 Jun 1999 15:17:42 GMT, you wrote:

>Hi. I am having a problem with plsql process. Here it is in point
>form.
>
>Multithreaded process using uniquet ranges to process in 4 threads.
>
>Each thread reads from 1 'temp' table and writes 4 records to
>destination table.
>
>About 1.4 million records in temp table therefore almost 6 million
>being written to destination table. Rate of insertion is about 14000
>rows per minute (when executed in single thread).
>
>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.
>

can you outline the logic? are you selecting for update from the temp table? how are you mediating access to that object?

>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.
>
>When program is executed in single thread, it performs successfully, it
>just takes too long.
>
>Any ideas about this would be helpful.
>
>Thanks in advance.
>
>Paul
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.

--
See http://govt.us.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Fri Jun 25 1999 - 11:53:35 CDT

Original text of this message

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