Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

unable to decrease SGA on 10g

579237Jul 8 2008 — edited Jul 8 2008

Hello Gurus

I have an Oracle 10g database on Solaris machine . following are the results of show SGA

Total System Global Area 1191182336 bytes
Fixed Size 2028080 bytes
Variable Size 355208656 bytes
Database Buffers 819200000 bytes
Redo Buffers 14745600 bytes

I want to decrease the SGA to 600 mb only but when i gave

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

then i decide to make changes in init.ora file . i put
sga_max_size = 600m
but that too of no use i got
Specified value of sga_max_size is too small, bumping to 1103101952
in alert log file

please suggest what i'm doing wrong and what should be the proper way to do it

thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 5 2008

Added on Jul 8 2008

#general-database-discussions

3 comments

3,349 views