Alter the size of sga as required. Increase sga_max_size to 6 gb as below sql> alter system set sga_max_size=6144m. I am increasing up to 2g; Check the memory of your operating system before increasing the sga size. If you make the sga too small on a working system, you can negatively impact performance, or in a worst case, crash the database. Then round this value to the nearest hundredth. Increase the oracle sga_max_size setting in your pfile that you created from your spfile. An experienced dba told me that the best way to estimate size for sga is to set aside 40% of memory for sga i.e for 2gb memory. Sql> alter system set sga_max_size=700m scope=spfile; (total sga size in gig) x 1024.

Sql>lter system set sga_max_size=524m scope=spfile; Connect to the database sysdba sqlplus sys/[email protected]as sysdba 2. Increase the oracle sga_max_size setting in your pfile that you created from your spfile. I am increasing up to 2g; Sql> alter system set sga_max_size=700m scope=spfile; Before you can increase memory in oracle database, you must first understand four oracle memory parameters which govern the instance. Increase sga_max_size to 6 gb as below sql> alter system set sga_max_size=6144m. Alter the size of sga as required. An experienced dba told me that the best way to estimate size for sga is to set aside 40% of memory for sga i.e for 2gb memory. You can expand the total sga size to a value equal to the sga_max_size parameter.

Check the memory of your operating system before increasing the sga size. Sql>lter system set sga_max_size=524m scope=spfile; How much memory should i allocate to sga? The value of the sga_max_size parameter defaults to the aggregate setting of all the sga components. Before you can increase memory in oracle database, you must first understand four oracle memory parameters which govern the instance. So the /boot/grub/grub.conf file entry. If you make the sga too small on a working system, you can negatively impact performance, or in a worst case, crash the database. Hi, iam using oracle 9i os solaris version 9.2.0.6 i am new to oracle database and i learn dba any help me. Connect to the database sysdba sqlplus sys/[email protected]as sysdba 2. Increase sga_max_size to 6 gb as below sql> alter system set sga_max_size=6144m.