JZTXT

Oracle 限制内存使用

发布时间 2023-06-17 14:28:16作者: wolbo
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