1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32
|
DEADLOCK DETECTED
Current SQL statement for this session:
insert into TABLEY(a,b,c) values (a1,b1,c1)
The following deadlock is not an ORACLE error. It is a
deadlock due to user error in the design of an application
or from issuing incorrect ad-hoc SQL. The following
information may aid in determining the deadlock:
Deadlock graph:
---------Blocker(s)-------- ---------Waiter(s)---------
Resource Name process session holds waits process session holds waits
TX-AAA 33 53 X 37 51 S
TX-AAA 37 51 X 33 53 S
session 53: DID 0001-0021-000000C1 session 51: DID 0001-0025-00000060
session 51: DID 0001-0025-00000060 session 53: DID 0001-0021-000000C1
Rows waited on:
Session 51: obj - rowid = 99X99X9X - XXpoxeXXXAAAAAAAA
(dictionary objn - 999, file - 10, block - 0, slot - 0)
Session 53: obj - rowid = 99X99X9X - XXpoxeXXXAAAAAAAA
(dictionary objn - 999, file - 10, block - 0, slot - 0)
Information on the OTHER waiting sessions:
Session 51:
pid=99 serial=9999 audsid=9999 user: 99/USER
O/S info: user: user, term: , ospid: 999999, machine: hostname
program: blabla@hostname (TNS V1-V3)
application name: blabla@hostname (TNS V1-V3), hash value=0
Current SQL Statement:
insert into TABLEY(a,b,c) values (a1,b1,c1)
End of information on OTHER waiting sessions. |
Partager