ORA-30009: Not enough memory for string operation

ORA-30009: Not enough memory for string operation
Cause: The memory size was not sufficient to process all the levels of the hierarchy specified by the query.
Action: In WORKAREA_SIZE_POLICY=AUTO mode, set PGA_AGGREGATE_TARGET to a reasonably larger value. Or, in WORKAREA_SIZE_POLICY=MANUAL mode, set SORT_AREA_SIZE to a reasonably larger value.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:48

ORA-30009：没有足够的内存用于字符串操作,
.原因：内存大小不足以处理查询指定的层次结构的所有级别。,
.操作：在WORKAREA_SIZE_POLICY = AUTO模式下，将PGA_AGGREGATE_TARGET设置为相当大的值。或者，在WORKAREA_SIZE_POLICY =手动模式下，将SORT_AREA_SIZE设置为相当大的值。,
.

aiaiDBA

13718043309

010-86462881

ORA-30009: Not enough memory for string operation

1 个回答

相似问题