1.Memory_TARGET约等于数据库消耗的SGA和PGA内存总和
2.查找当前SGA值
show parameter sga_target
3.查找当前PGA值
SELECT VALUE FROM V$PGASTAT WHERE name='maximum PGA allocated';
4.将两值相加得到MEMORY_TARGET参数 例如(1200MB)
5. 用如下命令修改
alter system set MEMORY_MAX_TARGET=1200M SCOPE=SPFILE;
alter system set MEMORY_TARGET=2000M SCOPE=SPFILE;
alter system set SGA_TARGET=0 SCOPE=SPFILE;
alter system set PGA_AGGREGATE_TARGET=0 SCOPE=SPFILE;
SGA_TARGET PGA_AGGREGATE_TARGET 参数值为零,可以使数据库自动调整SGA和PGA值
补充: 可使用 select * from v$memory_target_advice order by memory_size;
2.查找当前SGA值
show parameter sga_target
3.查找当前PGA值
SELECT VALUE FROM V$PGASTAT WHERE name='maximum PGA allocated';
4.将两值相加得到MEMORY_TARGET参数 例如(1200MB)
5. 用如下命令修改
alter system set MEMORY_MAX_TARGET=1200M SCOPE=SPFILE;
alter system set MEMORY_TARGET=2000M SCOPE=SPFILE;
alter system set SGA_TARGET=0 SCOPE=SPFILE;
alter system set PGA_AGGREGATE_TARGET=0 SCOPE=SPFILE;
SGA_TARGET PGA_AGGREGATE_TARGET 参数值为零,可以使数据库自动调整SGA和PGA值
补充: 可使用 select * from v$memory_target_advice order by memory_size;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/23347737/viewspace-1084735/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/23347737/viewspace-1084735/