ORA-12829: Deadlock - itls occupied by siblings at block string of file string

ORA-12829: Deadlock - itls occupied by siblings at block string of file string
Cause: parallel statement failed because all itls in the current block are occupied by siblings of the same transaction.
Action: increase MAXTRANS of the block or reduce the degree of parallelism for the statement. Reexecute the statement. Report suspicious events in trace file to Oracle Support Services if error persists.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:40

ORA-12829：死锁 - 由文件字符串的块字符串处的兄弟姐妹占用的itlock,
.原因：并行语句失败，因为当前块中的所有it都由同一事务的兄弟节点占用。,
.操作：增加块的MAXTRANS或减少语句的并行度。重新执行语句。如果错误仍然存??在，请将跟踪文件中的可疑事件报告给Oracle支持服务。,
.

aiaiDBA

13718043309

010-86462881

ORA-12829: Deadlock - itls occupied by siblings at block string of file string

1 个回答

相似问题