Which three are true concerning Exadata Smart Flash Cache on X6 Database Machines with High Capacity
Storage Servers?
A.
The “keep” cache is limited to a maximum of 80% of the total Smart Flash Cache capacity.
B.
Smart Scan will always use the Smart Flash Cache for all I/Os fast full index capacity.
C.
Smart Scan will always use the Smart Flash Cache for all I/Os for full table scans.
D.
Single block reads can benefit from Smart Flash Cache.
E.
Multiblock reads can benefit from Smart Flash Cache.
Explanation:
D: By default Exadata stores only small I/Os in the Exadata Smart Flash Cache. Small I/Os in most cases are single-block reads. During a full table scan Oracle requests blocks in multiblock lumps (by default 16 blocks), and these are
Incorrect Answers:
C: Oracle has over time has almost completely eliminated caching of table scan blocks from the buffer cache and why by default Exadata does not cache full table scan blocks in the Exadata Smart Flash Cache.
During a full table scan Oracle requests blocks in multiblock lumps (by default 16 blocks), and these are not stored in the Exadata Smart Flash Cache unless you change the CELL_FLASH_CACHE clause for the segment.References: http://www.informit.com/articles/article.aspx?p=2418151&seqNum=3