ORA-30927: Unable to complete execution due to failure in temporary table transformation

ORA-30927: Unable to complete execution due to failure in temporary table transformation
Cause: In memory temporary tables we create are aged out of shared pool before we are able to grab them again.
Action: Reduce activities that use a lot of shared pool space or wait for a while, then retry.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:49

ORA-30927：由于临时表转换失败，无法完成执行,
.原因：在我们创建的内存临时表中，在我们能够再次抓取它们之前，已经超出共享池。,
.操作：减少使用大量共享池空间或等待一段时间的活动，然后重试。,
.

aiaiDBA

13718043309

010-86462881

ORA-30927: Unable to complete execution due to failure in temporary table transformation

1 个回答

相似问题