读书人

碰到一次dead lock

发布时间: 2012-08-08 14:32:45 作者: rapoo

遇到一次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.

读书人网 >其他数据库

热点推荐