ORA-00827: could not shrink sga_target to specified value

ORA-00827: could not shrink sga_target to specified value
Cause: Attempted to shrink the SGA to the specified value but did not succeed because the SGA components could not be shrunk as they were already at their minimum sizes.
Action: Do not set sga_target to a value below the current value without first shrinking the individual SGA components.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:36

ORA-00827：无法将sga_target缩小到指定的值,
.原因：尝试将SGA收缩到指定值，但未成功，因为SGA组件无法收缩，因为它们已处于最小大小。,
.操作：不要将sga_target设置为低于当前值的值，而不先缩小单个SGA组件。,
.

aiaiDBA

13718043309

010-86462881

ORA-00827: could not shrink sga_target to specified value

1 个回答

相似问题