Oracle/HP Best Practices Guide for HP IO Accelerators

Single-instance performance architectures 25
db_flash_cache_size=xxG (this value depends on the size of the SSD
device)
3. Stop and then restart the Oracle database.
To use flash cache, create or update schema objects with the flash_cache storage clause specified. For
example:
SQL> create table TB_TEST01 storage( flash_cache keep) as select * from
all_objects;
Table created.
SQL> select table_name, flash_cache from user_tables;
TABLE_NAME FLASH_C
------------------------------ -------
TB_TEST01 KEEP
For more information on the options for the flash_cache storage clause, see "Using flash cache (on
page 24)."