OraFAQ Forum: Server Administration » Unable to increase the size of sga

Home » RDBMS Server » Server Administration » Unable to increase the size of sga (Oracle,10g,RHEL5)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Unable to increase the size of sga [message #541718]

Thu, 02 February 2012 00:37

kailas
Messages: 21
Registered: September 2011
Location: pune

Junior Member

I am trying to increase the size of sga or you can say that i want to make my sga in automatic memory management

Following is the steps i am trying

SQL> show parameter sga_max_size;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
sga_max_size                         big integer 96M
SQL>

after that i am trying to increase the size

SQL> alter system set sga_max_size = 200m; 
alter system set sga_max_size = 200m
                 *
ERROR at line 1:
ORA-02095: specified initialization parameter cannot be modified

Report message to a moderator