使用条件:Linux或Solaris机器, AWR中建议doule buffer cache, db file sequential read是top wait event. 大小:2-10倍的buffer c
使用条件:
Linux或Solaris机器, AWR中建议doule buffer cache, db file sequential read是top wait event.
大小:
2-10倍的buffer cache.不能小于2倍. 如果使用ASMM, 2-10倍的SGA_TARGET
两个参数:
DB_FLASH_CACHE_FILE
Specifies a list of paths and file names for the files to contain the flash cache, in either the operating system file system or an Oracle Automatic Storage Management disk group. If a specified file does not exist, the database creates it during startup. Each file must reside on a flash disk device. If you configure the flash cache on a disk drive (spindle), performance may suffer. A maximum of 16 files is supported.
DB_FLASH_CACHE_SIZE
Specifies the size of each file in the flash cache. Each size corresponds with a file specified in db_flash_cache_file. The files and sizes correspond in the order that they are specified. An error is raised if the number of specified sizes does not match the number of specified files.
Each size specification must be less than or equal to the physical memory size of its flash disk device. The size is expressed as nG, indicating the number of gigabytes (GB). For example, to specify a 16 GB flash cache, set db_flash_cache_size value to 16G.
2088shop商城购物系统是商城系统中功能最全的一个版本：非会员购物、商品无限级分类、不限商品数量、商品多级会员定价、上货库存、Word在线编辑器、订单详情销售报表、商品评论、留言簿、管理员多级别、VIP积分、会员注册积分奖励、智能新闻发布、滚动公告、投票调查、背景图片颜色更换、店标上传、版权联系方式修改、背景音乐（好歌不断）、广告图片支持Flash、弹出浮动广告、搜索引擎关健词优化、图文友情联
使用方法:
alter system set altdb_flash_cache_file = '/dev/raw/sda' scope=spfile;
alter system set db_flash_cache_size = 32G scope=spfile;
将db_flash_cache_size设为0 可以disable flash cache. 再设回来可以enable. 但不允许动态修改db_flash_cache_size的值.
对于RAC的环境, 需要在每个instance上面都设置以上两个参数 并且不能使用同一个file.
，
