ORA-00839: SGA_TARGET cannot be modified to the specified value

ORA-00839: SGA_TARGET cannot be modified to the specified value
Cause: The specified value of SGA_TARGET was not compatible with current settings of PGA_AGGREGATE_TARGET and MEMORY_TARGET/MEMORY_MAX_TARGET.
Action: Set SGA_TARGET to be no more than the difference of MEMORY_TARGET/MEMORY_MAX_TARGET and PGA_AGGREGATE_TARGET. Also ensure that the current PGA memory used for non-auto workareas is low.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:36

ORA-00839：SGA_TARGET不能修改为指定的值,
.原因： SGA_TARGET的指定值与PGA_AGGREGATE_TARGET和MEMORY_TARGET / MEMORY_MAX_TARGET的当前设置不兼容。,
.操作：将SGA_TARGET设置为不超过MEMORY_TARGET / MEMORY_MAX_TARGET和PGA_AGGREGATE_TARGET的差值。还要确保用于非自动工作区域的当前PGA内存较低。,
.

aiaiDBA

13718043309

010-86462881

ORA-00839: SGA_TARGET cannot be modified to the specified value

1 个回答

相似问题