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

Error Message

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.

You May Also Like

Leave a Reply?