Hello,
I am having problem with changing the parameter INMEMORY_SIZE. I used this method to set this parameter:
ALTER SYSTEM SET inmemory_size=300M scope=spfile;
And it raised the error: ORA-02096: specified initialization parameter is not modifiable with this option
02096. 00000 - "specified initialization parameter is not modifiable with this option"
*Cause: Though the initialization parameter is modifiable, it cannot be modified using the specified command.
The default value is 0, and I checked that it is modifiable:
Name | ISSYS_MODIFIABLE |
inmemory_size | IMMEDIATE |
Is there anyone know what is the problem?
Jay