Modify the size of the oracle database SGA and PGA

Modify the size of the oracle database SGA and PGA to modify the size of the SGA and PGASGA: Generally, 20% of the physical memory is used for the operating system reservation, and 80% of the other is used for the database. The SGA common database can be allocated between 40%-60%, and the PGA can be allocated between 20%-40%. Www.2cto.com 1. Log On As A dba and view the SGA information: SQL> show parameter sga; view the PGA information: SQL> show parameter pga; 2. Modify sga_targetSQL> alter system set sga_target = 436 M; 3. Modify sga_max_sizeSQL> alter system set sga_max_size = 436 M scope = spfile; www.2cto.com 4. Restart the database to make it take effect: SQL> shutdown immediate; # note that the above two operations must be completed before the restart, And the sga_target must not be greater than the sga_max_size, which is generally equal. Otherwise, the database may fail to start. SQL> startup 5. Check if SGA is effective: SQL> show parameter sgaNAME TYPE VALUE =----------- lock_sga boolean FALSEpre_page_sga boolean FALSEsga_max_size big integer 436Msga_target big integer 436 M