Which three attributes are likely to result in data being cached in the Exadata Smart Flash Cache?
A.
CELL_FLASH_CACHE attribute on the data object
B.
CACHE hint In the SQL statement
C.
Data from a table scan
D.
Small data less than 128 KBs
E.
Control file I/Os
Explanation:
A: Preferential treatment over which database objects are cached is also provided
with the Exadata Smart Flash Cache. For example, objects can be pinned in the cache and always
be cached, or an object can be identified as one which should never be cached. This control is
provided by the new storage clause attribute, CELL_FLASH_CACHE, which can be assigned to a
database table, index, partition and LOB column.
Incorrect:
C: Scans, or sequentially reading tables, generally would not be cached since sequentially
accessed data is unlikely to be subsequently followed by reads of the same data.
http://www.oracle.com/technetwork/middleware/bi-foundation/exadata-smart-flash-cache-twp-v5-1-128560.pdf