Amazon books

Friday, October 16, 2015

Enabling New Flash Cache Compression on Exadata Cells

The flash cards F40 and F80 support flash cache compression and uncompressed tables for example can reach a 4 times compression ratio.

To enable compression follow these steps:

1-Flush all the flash cache in cell

 CellCLI> alter flashcache all flush

2-Drop the flashcache

CellCLI> drop flashcache all

3-Drop all flash log

  CellCLI> dorp flashlog all

4-Drop all cell flash cache disks

  CellCLI> drop celldisk all flashdisk

5-On Cell that you want to enable flash cache compression run:

CellCLI> alter cell flashCacheCompress = TRUE

6-Create cell disk with flash disks

  CellCLI> create celldisk all flashdisk

7-Create flash log

  CellCLI> create flashlog all

8-Finally create flashcache

  CellCLI> create flashcache all

Best Regards,
Paulo Portugal

ps: for X3 run
CellCLI> alter cell flashCacheCompX3Support = TRUE

No comments:

Post a Comment