oracle deadlock error on insert

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.

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. Received on Fri Jun 25 1999 - 10:17:42 CDT