1 2 Previous Next 16 Replies Latest reply on May 24, 2013 10:27 AM by John Stegeman

    unable to set sga_max_size parameter value

      Hi experts,

      To tune the OID11g the DB parameter recommendation is :

      sga_target Minimum 60% of RAM
      sga_max_size Minimum 60% of RAM
      db_cache_size Minimum 60% of RAM

      So what is RAM size..is that the RAM size on the linux BOX which is 8 GB in my case
      or RAM size assigned to Oracle DB?

      If I take RAM size 8 GB I am not able to modify the parameter. I am getting below error:

      SQL> alter system set sga_max_size=4916M scope=both;
      alter system set sga_max_size=4916M scope=both
      ERROR at line 1:
      ORA-02095: specified initialization parameter cannot be modified

      how to check that total memory assigned to Oracle DB?

      Please let me know the correct way to set these param, any help apprecited.
        1 2 Previous Next