Have A Info About How To Increase Sga_max_size

As others said, if you are using spfile alter.

How to increase sga_max_size. Make the entry in the pfile as sga_max_size=value. 7 rows this causes more address space to be reserved for expansion of the sga. Sga_max_size can't be changed dynamically.

Connect to the database sysdba sqlplus sys/oracle@op as sysdba 2. It uses the spfilesid.ora in the $oracle_home/dbs directory. Sql> alter system set sga_target=750m scope=both;

The oracle sga_max_size parameter sets the hard limit up to which sga_target can dynamically adjust sizes. Memory_target and memory_max_target from 11g onward, you do not need to. To install oracle 9.2.0.2 patch i need to increase shared_pool_size and java_pool_size to atleast 150m each.

Alter system set sga_max_size = 12 g scope = spfile; Sql> alter system set sga_max_size=2g scope=spfile; Sql> alter system set sga_target=2g scope=spfile;

Normally oracle no longer uses the init.ora file anymore. Sql> alter system set sga_target=1024m. Usually, sga_max_size and sga_target will be the same value, but there may be.

This parameter sets the upper limit for sga_target. Sql> alter system set sga_max_size=750m scope=spfile; To increase the sga size for your instance or to decrease, 1.

Tio change the parameter (s) you. The sga_max_sze parameter is not dynamic in oracle 10g. Sga_max_size specifies the maximum size of the sga for the lifetime of the instance.

Hi coki.you can not resize the parametersga_max_size dynamically.you have to shutdown the database and open the initsid.ora file and set the parameter sga_max_size=kb/mb and then.