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 = 10240M sid=’bh1′ scope=spfile;
alter system set db_flash_cache_size = 512M sid=’bh2′ scope=spfile;
alter system set db_flash_cache_size = 20480M sid=’bh3′ scope=spfile;
alter system set db_flash_cache_size = 1024M sid=’bh4′ scope=spfile;

This entry was posted in 脚本语言. Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *