Forum Stats

  • 3,814,863 Users
  • 2,258,921 Discussions
  • 7,892,882 Comments

Discussions

Cannot set INMEMORY_SIZE

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

Tagged:

Best Answer

Answers