Home » RDBMS Server » Server Administration » Unable to increase the size of sga (Oracle,10g,RHEL5)
Unable to increase the size of sga [message #541718] Thu, 02 February 2012 00:37 Go to next message
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



Re: Unable to increase the size of sga [message #541723 is a reply to message #541718] Thu, 02 February 2012 01:03 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
"scope=spfile" and restart the db.

Regards
Michel
Previous Topic: USERS tablespace
Next Topic: Incremental checkpoint and SCN
Goto Forum:
  


Current Time: Thu Mar 28 06:47:27 CDT 2024