前面介绍了Oracle的基本参数,从这节开始讲其他的参数,参数从v$parameter中提取 基本参数请看如下链接: [http://www.zhaibibei.cn/oralce/oracle-parameter/](http://www.zhaibibei.cn/oralce/oracle-parameter/) 如无特殊说明数据库版本为11.2 ------- **memory_max_target** [image:330 size:orig] 1. 参数类型:整型 2. 语法:MEMORY_MAX_TARGET = integer [K | M | G] 2. 默认值: 0 4. 修改需要重启数据库 5. 取值范围:0到操作系统最大内存 6. 基本参数:否 ------ 该参数决定MEMORY_TARGET参数可以设置的最大值 具体见下面各个参数的解释 ------- **更多信息** [SGA_TARGET](https://mp.weixin.qq.com/s?__biz=MzI5NjIxNTU2OQ==&mid=2650215831&idx=1&sn=24a9c69638f8ef2949b817d664427c0e&chksm=f44400e9c33389ff8f4f0e4b942774662fc6fa955ba8c2a323cf30b9062b19c9b2149d240b20&scene=21#wechat_redirect) [PGA_AGGREGATE_TARGET](https://mp.weixin.qq.com/s?__biz=MzI5NjIxNTU2OQ==&mid=2650215826&idx=1&sn=bc8c185850edb991a9cd8a10949cec1b&chksm=f44400ecc33389fabc96425370b6edc1a87dc57603daea6688e8bfbf15647e1628e5774f7708&scene=21#wechat_redirect) [memory_target](http://www.zhaibibei.cn/oralce/oracle-parameter/memory_target/) -------- **实际截图:** [image:331 size:orig] ----- **参考连接** [https://docs.oracle.com/cd/E11882_01/server.112/e40402/initparams142.htm#REFRN10284](https://docs.oracle.com/cd/E11882_01/server.112/e40402/initparams142.htm#REFRN10284) ---------- 下期参数 **control_files**