This discussion is archived
1 2 Previous Next 16 Replies Latest reply: May 24, 2013 3:27 AM by John Stegeman RSS

unable to set sga_max_size parameter value

999875 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points