Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: oracle deadlock error on insert
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