modifying Oracle memory consumption

Modify Oracle Memory footprint?

1234567891011121314151617181920

# su oracle   $cd $ORACLE_HOME   $./sqlplus /nolog   >connect / as sysdba;    >show parameter sga; (查看内存占用情况)     NAMETYPE          VALUE  ------------------------------------ ----------- -------------  lock_sga                       boolean       FALSE  pre_page_sga                   boolean       FALSE  sga_max_size                   big integer 800M  sga_max_size                   big integer 800M >alter system set sga_max_size=2048m scope=spfile; >alter system set sga_target=1024m scope=spfile;

Then restart the database, then show parameter SGA is OK.

1	altersystem setmemory_target=2048m scope=spfile;

Note: The sga_max_size cannot be greater than memory_target, or the database fails to start.