This content has been marked as final. Show 3 replies
for db using spfile :
alter system set sga_target='200M' scope=both;-no db restart required,as long as the value did not exceed sga_max_size
alter system set sga_max_size ='200M' scope=both; db restart required
for db using pfile:
edit your pfile, by changing the sga_target and sga_max_size.
restart your db.
it should change now.
You have to mention the version of database
if its 9i and have spfile
use alter system set sga_max_size=value scope=spfile ;
restart the database
if it 10g and using ASMM then
set sga_max_Size as above
and use sga_target(dynamic) to control the memory allocation for sga components
alter system set sga_target = value
if 11g and using AMM
difference in 11g and 10g if we define below parameters it considers pga memory allocation as well
then use memory_max_target(static) and memory_target(dynamic)
refer oracle database reference to understand them
Lingan patil(oracle dba) wrote:I guess the more important question would be that whether you really need to do so i.e. that whether you really need to increase the SGA size from its current value. So besides your oracle version, if you can tell that why you want do it, it would fetch more appropriate replies.
how to increase sga size in oracle
please send example documentation