oracle内存管理
oracle 11g中 内存用了自动化管理
MEMORY_TARGET的值大于/dev/shm 就会报错 ORA-00845: MEMORY_TARGET not supported on this system错误,
redhat系列系统中,/dev/shm的默认值是系统总内存的一半
alter system set memory_max_target=1024M scope=spfile;
alter system set memory_target=1024M scop=spfile;
alter system set sga_target=0 scope=spfile;
alter system set sga_max_size=0 scope=spfile;
alter system set pga_aggregate_target=0 scope=spfie;
--查看sga
show parameter sga;
--查看实际pga
select * from v$pgastat