设置内存管理

SELECT name, value
FROM   v$parameter
WHERE  name like '%target%';

select value/1024/1024/1024 as Value_G from dual;


select * from V$MEMORY_TARGET_ADVICE;

SELECT (
   (SELECT SUM(value) FROM V$SGA) -
   (SELECT CURRENT_SIZE FROM V$SGA_DYNAMIC_FREE_MEMORY)
   ) "SGA_TARGET"
FROM DUAL;

-- 设置自动内存管理
alter system set MEMORY_MAX_TARGET=230G scope=spfile;  -- MEMORY_TARGET参数所能动态设定的最大值，不能动态调整，需要重启数据库
alter system set MEMORY_TARGET=200G scope=spfile;  -- oracle所能使用的最大内存，该参数可以动态调整