日期:2014-05-16 浏览次数:20624 次
遇到一次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.