?# su oracle

????$cd $ORACLE_HOME

??? $./sqlplus /nolog

??? >connect / as sysdba;

??? >show parameter sga; (查看内存占用情况)

??? ??NAME?????????????????????????????????? TYPE????????? 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;

??然后重启数据库，再show parameter sga就OK了。

?

alter system set memory_target=2048m scope=spfile;

注意：sga_max_size不能大于memory_target，不然数据库启动失败。

?