Daily Archives: May 17, 2011

How to enable flash cache in 11.2

The following are my setting for your reference. alter system set db_flash_cache_file =’/oraTB/orahome/dbs/flash_file01.dbf’ sid=’bh1′  scope=spfile; alter system set db_flash_cache_file =’/oraTB/orahome/dbs/flash_file02.dbf’ sid=’bh2′  scope=spfile; alter system set db_flash_cache_file =’/oraTB/orahome/dbs/flash_file03.dbf’ sid=’bh3′  scope=spfile; alter system set db_flash_cache_file =’/oraTB/orahome/dbs/flash_file04.dbf’ sid=’bh4′  scope=spfile; alter system set db_flash_cache_size … Continue reading

Posted in 脚本语言 | Leave a comment