DEADLOCK DETECTED ( ORA-00060 )
[Transaction Deadlock]
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-002f0014-000500b8       138    1295     X            124    1286           X
TX-00120014-003a4fa1       124    1286     X            138    1295           X
session 1295: DID 0001-008A-00000003    session 1286: DID 0001-007C-00000003
session 1286: DID 0001-007C-00000003    session 1295: DID 0001-008A-00000003
Rows waited on:
Session 1286: obj - rowid = 0000D168 - AAANFoAAPAAAACSAA4
  (dictionary objn - 53608, file - 15, block - 146, slot - 56)
Session 1295: obj - rowid = 0000D168 - AAANFoAAPAAMVseAAn
  (dictionary objn - 53608, file - 15, block - 3234590, slot - 39)
Information on the OTHER waiting sessions:
Session 1286:
  sid: 1286 ser: 90 audsid: 476518828 user: 120/SD_HOSPITAL
    flags: (0x100041) USR/- flags_idl: (0x1) BSY/-/-/-/-/-
    flags2: (0x8)
  pid: 124 O/S info: user: SYSTEM, term: HISDB, ospid: 6264
    image: ORACLE.EXE (SHAD)
  O/S info: user: Administrator, term: unknown, ospid: 1234, machine: WIN-NFO1QHL02QK
            program: JDBC Thin Client
  application name: JDBC Thin Client, hash value=2546894660
  Current SQL Statement:
  
UPDATE BQ_BRLDXX A SET BQJSRQ=(SELECT NVL(SUBSTRB(MIN(JSRQ00||JSSJ00),1,8),'99991231') FROM BQ_BRLDXX B WHERE B.ZYID00=A.ZYID00 AND A.BQH000=B.BQH000 AND B.JSZT00 IN ('出院','转出') AND B.JSRQ00||B.JSSJ00>A.QSRQ00||A.QSSJ00) WHERE QSZT00 IN ('新入','转入','入院') AND BQJSRQ='99991231' AND YXBZ00='1'
End of information on OTHER waiting sessions.
Current SQL statement for this session:
UPDATE BQ_BRLDXX A SET BQJSRQ=(SELECT NVL(SUBSTRB(MIN(JSRQ00||JSSJ00),1,8),'99991231') FROM BQ_BRLDXX B WHERE B.ZYID00=A.ZYID00 AND A.BQH000=B.BQH000 AND B.JSZT00 IN ('出院','转出') AND B.JSRQ00||B.JSSJ00>A.QSRQ00||A.QSSJ00) WHERE QSZT00 IN ('新入','转入','入院') AND BQJSRQ='99991231' AND YXBZ00='1'