Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Oracle 8i Deadlock without deadlock graph on insert statement
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
![]() |
![]() |