前面介绍了Oracle的基本参数,从这节开始讲其他的参数,参数从v$parameter中提取 基本参数请看如下链接: [http://www.zhaibibei.cn/oralce/oracle-parameter/](http://www.zhaibibei.cn/oralce/oracle-parameter/) 如无特殊说明数据库版本为11.2 ------- **buffer_pool_keep** [image:355 size:orig] 1. 参数类型:整型 2. 语法:BUFFER_POOL_KEEP = {integer |(BUFFERS:integer, LRU_LATCHES:integer)} 2. 默认值:无 4. 修改:需改需要重启数据库 ------ **取值意义** 上图的参数截图为Oracle 9i 该参数指定Oracle实例中SGA中KEEP池中buffer的数量,也可以加上LRU latches的数量 该参数已被DB_KEEP_CACHE_SIZE参数取代,已经废弃 二者不能同时设定,否则会报错 举例: ``` BUFFER_POOL_KEEP = 5 BUFFER_POOL_KEEP = (BUFFERS:400, LRU_LATCHES:3) ``` -------- **实际截图:** [image:356 size:orig] ----- **参考连接** [db_keep_cache_size](http://www.zhaibibei.cn/oralce/oracle-parameter/db_keep_cache_size/) [https://docs.oracle.com/cd/A97630_01/server.920/a96536/ch118.htm](https://docs.oracle.com/cd/A97630_01/server.920/a96536/ch118.htm) ---------- 下期参数 **buffer_pool_recycle**