Oracle 限制内存使用

sqlplus / as sysdba

show parameter target

ALTER SYSTEM SET pga_aggregate_target = 300M SCOPE=SPFILE;

ALTER SYSTEM SET sga_target = 1000M SCOPE=SPFILE;

ALTER SYSTEM SET memory_max_target = 1G SCOPE=SPFILE;

shutdown immediate

startup