show spparameters 命令显示 spfile 修改后未重启生效的参数值 SQL> alter system set sga_max_size=4096M scope=spfile; System altered. SQL> alter system set sga_target=4096M scope=spfile; System altered. SQL> show spparameter sga SID NAME TYPE VALUE -------- ----------------------------- ----------- ---------------------------- * sga_max_size big integer 4G * sga_target big integer 4G SQL> show parameter sga NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ sga_max_size big integer 5040M sga_target big integer 5040M