Ace Info About How To Increase Sga_max_size

To increase the sga size for your instance or to decrease, 1.

How to increase sga_max_size. I wnat to change sga_target and sga_max_size in oracle xe but i ma getting this error when i am trying to start the database. Alter system set sga_max_size = 12 g scope = spfile; Sql> alter system set sga_max_size=750m scope=spfile;

This is a binary file. Memory_target and memory_max_target from 11g onward, you do not need to. Usually, sga_max_size and sga_target will be the same value, but there may be.

Make the entry in the pfile as sga_max_size=value. The sga_max_sze parameter is not dynamic in oracle 10g. This parameter sets the upper limit for sga_target.

As others said, if you are using spfile alter. It uses the spfilesid.ora in the $oracle_home/dbs directory. Sql> alter system set sga_target=1024m.

Normally oracle no longer uses the init.ora file anymore. 7 rows this causes more address space to be reserved for expansion of the sga. Sql> alter system set sga_max_size=2g scope=spfile;

Sql> alter system set sga_target=2g scope=spfile; Sga_max_size can't be changed dynamically. Connect to the database sysdba sqlplus sys/oracle@op as sysdba 2.