- 最后登录
- 2014-4-3
- 在线时间
- 23 小时
- 威望
- 55
- 金钱
- 388
- 注册时间
- 2011-12-6
- 阅读权限
- 50
- 帖子
- 32
- 精华
- 0
- 积分
- 55
- UID
- 98
|
发表于 2014-3-27 11:26:39
脚本里面的
REM================================MEMORY===================================
alter system set memory_target=0 scope=spfile;
alter system set memory_max_target=0 scope=spfile; ==>禁用AMM特性
应该去掉 memory_max_target=0,否则会遇到
ORA-00843: Parameter not taking MEMORY_MAX_TARGET into account
ORA-00849: SGA_TARGET 1065353216 cannot be set to more than MEMORY_MAX_TARGET 0.
或者改为reset memory_max_target |
|