实验：改变参数memory_max_target和memory_target

实验：改变参数memory_max_target和memory_target

1、必须保证pfile存在，否则实验出错就启动不了数据库了

create pfile from spfile

2、什么是memory_max_target和memory_target

memory_target=pga_aggregate_target+sga_target

pga_aggregate_target ：session总计可以使用最大PGA内存

sga_target：SGA可用内存（不是最大内存sga_max_size）

3、修改memory_max_target和memory_target 报错的几种情况

a) ORA-00843: Parameter not takingMEMORY_MAX_TARGET into account

ORA-00849: SGA_TARGET 943718400 cannot be set to more thanMEMORY_MAX_TARGET 4194304.

b) ORA-00838: Specified value ofMEMORY_TARGET is too small, needs to be at least 1000M

c) ORA-00837: Specified value ofMEMORY_TARGET greater than MEMORY_MAX_TARGET

--a、b、c三种情况只要做好memory_target=pga_aggregate_target+sga_target以及memory_target<memory_max_target就可用了

d) ORA-00845: MEMORY_TARGET notsupported on this system

--MEMORY_MAX_TARGET 的设置不能超过/dev/shm 的大小

[root@abc ~]#  df -h | grepshm

tmpfs           495M   72K 495M   1% /dev/shm – tmpfs一种基于内存的文件系统？（具体我也不太理解）

You have new mail in /var/spool/mail/root

[root@abc ~]#  mount-o remount,size=1G /dev/shm –挂载额外的参数remount重新转载

e) ORA-00843: Parameter not takingMEMORY_MAX_TARGET into account

ORA-00849: SGA_TARGET 943718400 cannot be set to more thanMEMORY_MAX_TARGET 0.

--alter system reset memory_max_target/memory_target就可用把他重设为0了