#这个大小决定了memory_target的大小,必须大于memory_target
mount -o remount,size=50G /dev/shm
alter system set memory_max_target=48000M scope=spfile;
alter system set memory_target=48000M scope=spfile;
ALTER SYSTEM SET SGA_TARGET = 0 SCOPE=SPFILE;
ALTER SYSTEM SET PGA_AGGREGATE_TARGET = 0 SCOPE=SPFILE;
show parameter target;
参考:https://blog.csdn.net/sunny05296/article/details/56495599。