Oralce中的flash cache
使用条件: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.
使用方法:
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.
,上一篇: PHP下使用mysqli的函数连接mysql出现warning: mysqli::real_connect(): (hy000/1040): ...,mysqlihy000
下一篇: php常见的错误类型及屏蔽方法
推荐阅读
-
Oralce中的flash cache
-
有关网页中的flash问题
-
ASP.NET中Application和Cache的区别分析
-
asp.net 使用驻留在页面中的Cache缓存常用可定时更新的数据
-
Flash中的ActionScript3.0脚本语言制作小游戏
-
内核中拥塞窗口初始值对http性能的影响分析 博客分类: kernel Google数据结构Blog算法Cache
-
ASP.NET中Application和Cache的区别分析
-
asp.net 使用驻留在页面中的Cache缓存常用可定时更新的数据
-
asp.net中Session缓存与Cache缓存的区别分析
-
asp.net中Session缓存与Cache缓存的区别分析