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.
Asked by Myeongsik Joo
(101 rep)
Aug 3, 2020, 06:08 AM
Last activity: Jun 19, 2025, 07:04 PM
Last activity: Jun 19, 2025, 07:04 PM