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!

increase the SGA_MAX_SIZE and SGA_TARGET parameters

636287Apr 29 2011 — edited Apr 29 2011

HI ,

I am using oracle 10g R2 and windows server 2003 .
My server is having 8 GB RAM .

I want to increase the SGA_MAX_SIZE and SGA_TARGET parameters .

I am using the below command , but getting the error

SQL> alter system set sga_max_size=2000M scope=spfile ;
alter system set sga_max_size=2000M scope=spfile
*
ERROR at line 1:
ORA-32001: write to SPFILE requested but no SPFILE specified at startup

Can someone please help ..

Locked Post

New comments cannot be posted to this locked post.

Locked on May 27 2011

Added on Apr 29 2011

#general-database-discussions

15 comments

4,752 views