Your customer has designated a number of database objects to be kept persistently in the Exadata Smart Flash Cache. What happens if the total size of these objects is greater than 80% of the size of…

The correct answer is C. Not all objects will be stored in Exadata Smart Flash Cache. We have 3 possible values for CELL_FLASH_CACHE : DEFAULT (the default), KEEP and NONE. Keep means that the sales table will be stored in the Flash Cache "more aggressively" than the default. in the Flash Cache, KEEP assigned objects are also subject to an age out policy - if…

Performance Tuning

Question

Your customer has designated a number of database objects to be kept persistently in the Exadata Smart Flash Cache. What happens if the total size of these objects is greater than 80% of the size of the available Exadata Smart Flash Cache?

Options

ANothing
BExadata Smart Flash Cache expands the allocation to hold the objects.
CNot all objects will be stored in Exadata Smart Flash Cache.
DOverall performance is increased as more objects fit into Exadata Smart Flash Cache.

How the community answered

(25 responses)

A
4% (1)
B
16% (4)
C
72% (18)
D
8% (2)

Explanation

We have 3 possible values for CELL_FLASH_CACHE : DEFAULT (the default), KEEP and NONE. Keep means that the sales table will be stored in the Flash Cache "more aggressively" than the default. in the Flash Cache, KEEP assigned objects are also subject to an age out policy - if those objects ain't accessed for a longer time, they will vanish from the flash cache to make room for objects with the default attribute. And yes, they cannot consume more than 80 % of the Flash Cache. If you assign objects with in summary more than 80 % of the Flash Cache with the CELL_FLASH_CACHE KEEP attribute - they will simply not all be flash cached -at the same

Topics

#Exadata#Smart Flash Cache#storage capacity#object caching

Community Discussion

No community discussion yet for this question.

Full 1Z0-536 Practice