Although the initialization parameters can be modified, they cannot be modified using the specified command
SQL> show parameter inmemory_size;
NAME TYPE VALUE
------------------------ ----------- ------
inmemory_size big integer 0
SQL> alter system set inmemory_size=200m scope=spfile;
alter system set inmemory_size=200m scope=spfile
*
ERROR at line 1:
ORA-02096: specified initialization parameter is not modifiable with this option
Check the v$parameter data dictionary view to see if a parameter can be changed in the session or at the system level
SQL> select isses_modifiable, issys_modifiable from v$parameter where name='inmemory_size'; ISSES_MODIFIABLE ISSYS_MODIFIABLE ---------------- ---------------- FALSE IMMEDIATE
In summary, I restarted the CDB and executed the command again after successful execution.
Enumeration value of issys_modifiable
| FALSE | Indicates that the parameter cannot change its value during the life cycle of the instance; the database needs to be restarted for the change to take effect |
| IMMEDIATE | The value indicates that it is dynamic and can be set to change the current active instance and restart the database in the future |
| DEFFERED | It is also dynamic, but the change will only affect subsequent sessions, the currently active session will not be affected and retain the old parameter values |