遇到一次dead lock

出埃及

于 2012-07-18 08:52:43 发布

阅读量600

点赞数

分类专栏： Oracle Base 文章标签： session parallel dictionary graph hp query

本文链接：https://blog.youkuaiyun.com/Coast_lichao/article/details/7757607

版权

Oracle Base 专栏收录该内容

8 篇文章

订阅专栏

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