ORA-00847: MEMORY_TARGET/MEMORY_MAX_TARGET and LOCK_SGA cannot be set together

ORA-00847: MEMORY_TARGET/MEMORY_MAX_TARGET and LOCK_SGA cannot be set together
Cause: MEMORY_TARGET/MEMORY_MAX_TARGET was set to a non-zero value and LOCK_SGA was also set
Action: Do not set MEMORY_TARGET or MEMORY_MAX_TARGET if LOCK_SGA is set to TRUE.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:36

ORA-00847：MEMORY_TARGET / MEMORY_MAX_TARGET和LOCK_SGA不能一起设置,
.原因： MEMORY_TARGET / MEMORY_MAX_TARGET设置为非零值，并且还设置了LOCK_SGA,
.操作：如果LOCK_SGA设置为TRUE，则不要设置MEMORY_TARGET或MEMORY_MAX_TARGET。,
.

aiaiDBA

13718043309

010-86462881

ORA-00847: MEMORY_TARGET/MEMORY_MAX_TARGET and LOCK_SGA cannot be set together

1 个回答

相似问题