Sunday, February 27, 2011

How to use Exadata Smart Flash Cache?

I posted about Oracle 11gR2 Flash Cache. I had to use both db_flash_cache_file and db_flash_cache_size parameters for Database Smart Flash Cache(this feature is supported on Exadata Environment). After I read Exadata Part IV: Flash Cache (by UWE HESSE). I interested about Exadata Smart Flash Cache. How to use Exadata Smart Flash Cache? - So... I tested:

On Storage:
CellCLI> list flashcache detail
< Nothing >

CellCLI> create flashcache all size=100g
Flash cache exacel01_FLASHCACHE successfully created

CellCLI> list FLASHCACHECONTENT
< Nothing >

CellCLI> list flashcache detail
name: exacel01_FLASHCACHE
cellDisk:
creationTime: 2011-02-27T01:38:12+07:00
degradedCelldisks:
effectiveCacheSize: 100G
id:
size: 100G
status: normal
On Database:
SQL> create table tb_test as select * from all_objects;

Table created.
CELL_FLASH_CACHE storage clause attribute allows the override of the automatic caching policy in Exadata Smart Flash Cache when the COMPATIBLE parameter is greater than or equal to 11.2.0.0. CELL_FLASH_CACHE storage_clause option:
- NONE
- DEFAULT
- KEEP

On Database:
SQL> alter table tb_test storage (cell_flash_cache keep);

Table altered.

SQL> select * from tb_test;

SQL> select name, value from v$sysstat where name in ('physical read total IO requests','cell flash cache read hits');

NAME VALUE
---------------------------------------------------------------- ----------
physical read total IO requests 586219
cell flash cache read hits 86
On Storage:
CellCLI> list FLASHCACHECONTENT
2080757153 0 40
2080757153 0 227
2080757153 0 288
2080757153 0 290
2080757153 0 384
2080757153 1 6548
2080757153 1 6550
2080757153 1 15926
2080757153 1 16513
2080757153 1 16991
2080757153 1 17170
OK... just created flashcache!!! and used CELL_FLASH_CACHE storage_clause option on Database.

read more(Exadata Smart Flash Cache and the Sun Oracle Database Machine)
***

No comments: