On Storage:
CellCLI> list flashcache detailOn Database:
< 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
SQL> create table tb_test as select * from all_objects;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:
Table created.
- NONE
- DEFAULT
- KEEP
On Database:
SQL> alter table tb_test storage (cell_flash_cache keep);On Storage:
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
CellCLI> list FLASHCACHECONTENTOK... just created flashcache!!! and used CELL_FLASH_CACHE storage_clause option on Database.
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
read more(Exadata Smart Flash Cache and the Sun Oracle Database Machine)
***
No comments:
Post a Comment