I try to this in oracle XE 18c. I cant't alter inmemory_size property but can alter sga_target.
Who relieve me?

SQL> alter system set inmemory_size=200M;
alter system set inmemory_size=200M
ERROR at line 1:
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-02095: specified initialization parameter cannot be modified

SQL> alter system set sga_target=1024M;

System altered.

1 Answer 1


inmemory_size can not be modified online. Modify it in the spfile:

alter system set inmemory_size=200M scope=spfile;

Then restart the database.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.