12C内存相关参数修改

MEMORY_MAX_TARGET数值修改

默认的原始参数

SHOW PARAMETER TARGET

select value from v$pgastat where name=‘maximum PGA allocated’;

SHOW PARAMETER MEMORY_TARGE

SHOW PARAMETER MEMORY_MAX_TARGET

SHOW PARAMETER SGA_TARGET

SHOW PARAMETER PGA_AGGREGATE_TARGET

ALTER SYSTEM SET MEMORY_MAX_TARGET = 6G SCOPE = SPFILE;

SHUTDOWN IMMEDIATE
startup

tmpfs /dev/shm tmpfs defaults,size=8192m 0 0

mount -o remount /dev/shm


查看修改

SHOW PARAMETER MEMORY_MAX_TARGET

修改MEMORY_TARGE值

查看原始的值

ALTER SYSTEM SET memory_target = 5G;

SHOW PARAMETER memory_target

查看 修改

修改SGA_TARGET

查看原来的参数

ALTER SYSTEM SET SGA_TARGET = 0;

查看修改

修改PGA_AGGREGATE_TARGET

查看PGA_AGGREGATE_TARGET

ALTER SYSTEM SET PGA_AGGREGATE_TARGET = 0;

查看修改

修改MEMORY_TARGET

查看原始值


查看修改结果

启用手动共享内存管理

确定SGA_TARGET和MEMORY_TARGET等于0

SHOW PARAMETER SGA_TARGET
SHOW PARAMETER MEMORY_TARGET

SGA_TARGET

ALTER SYSTEM SET SGA_TARGET = 0 SCOPE = SPFILE;

查看修改结果

修改DB_CACHE_SIZE

ALTER SYSTEM SET DB_CACHE_SIZE=80M SCOPE = SPFILE;

修改PGA_AGGREGATE_TARGET大小

PGA_AGGREGATE_TARGET


ALTER SYSTEM SET PGA_AGGREGATE_TARGET=1024M SCOPE = SPFILE;

查看修改