遇到一次dead lock
遇到一次dead lock:
ERROR at line 1:ORA-12801: error signaled in parallel query server P022ORA-00060: deadlock detected while waiting for resourceCurrent SQL statement for this session:create table hp_sh_recovery22 parallel 20 tablespace test as select*from hp_sh_recoveryDeadlock graph: ---------Blocker(s)-------- ---------Waiter(s)---------Resource Name process session holds waits process session holds waitsCI-00000001-00000005 86 78 X 70 64 Xsession 78: DID 0001-0035-00000183 session 64: DID 0001-0035-00000183Rows 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.