Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Oracle 8i Deadlock without deadlock graph on insert statement

Oracle 8i Deadlock without deadlock graph on insert statement

From: <vdemers_at_gmail.com>
Date: Fri, 20 Jul 2007 19:30:25 -0000
Message-ID: <1184959825.899401.68100@w3g2000hsg.googlegroups.com>


Hi, I have a PL/SQL procedure in a package that generates invoices by inserting a row in a table. Each invoice is produced in it's own transaction (there's a commit after each invoice is created). After this row is inserted (this is the insert producing the deadlock) and some other rows in others tables are updated, the transaction is commited and then another transaction does the same operation again and again for a few thousand times. The application is deployed at 10 clients sites and works without any problem, but the client with the biggest database has been having this same deadlock since two days while running the procedure :

The problem is : why isn't there a deadlock graph ???

Thanks in advance.
Vince

Received on Fri Jul 20 2007 - 14:30:25 CDT

Original text of this message

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