sqlplus / as sysdba
SQL>alter system set sga_target=1024m scope=spfile;
SQL>alter system set sga_max_size=1024m scope=spfile;
重启oracle
调整后:
可以看到下降的曲线
sqlplus / as sysdba
SQL>alter system set sga_target=1024m scope=spfile;
SQL>alter system set sga_max_size=1024m scope=spfile;
重启oracle
调整后:
可以看到下降的曲线