Effective attributes for being cached in the Exadata Smart Flash Cache
1.CELL_FLASH_CACHE attribute on the data object
2.CACHE hint In the SQL statement
3.Small data less than 128 KBs
4.Control file I/Os
I missed above question, and answer is 1,2,3. I thought 1,3,4.
Hereby I have questions below.
Is CACHE hint effective for data being cached in the Exadata Smart Flash Cache? In the standard Database, the CACHE hint is effective for data being kept in Buffer Cache.
In other words, Is CACHE hint in Exadata Environment effective for data to be kept in Buffer Cache on the database server instead of Smart Flash Cache?