日期:2014-05-16  浏览次数:20624 次

遇到一次dead lock
遇到一次dead lock:
ERROR at line 1:
ORA-12801: error signaled in parallel query server P022
ORA-00060: deadlock detected while waiting for resource

Current SQL statement for this session:
create table hp_sh_recovery22 parallel 20 tablespace test as select*from hp_sh_recovery
Deadlock graph:
                       ---------Blocker(s)--------  ---------Waiter(s)---------
Resource Name          process session holds waits  process session holds waits
CI-00000001-00000005        86      78     X             70      64           X
session 78: DID 0001-0035-00000183      session 64: DID 0001-0035-00000183
Rows waited on:
Session 64: obj - rowid = 0000D626 - AAANYmAAIAAAeP6AAA
  (dictionary objn - 54822, file - 8, block - 123898, slot - 0)
Information on the OTHER waiting sessions:
End of information on OTHER waiting sessions.