Oracle Continuous Innovation

QUESTION 41

Which three attributes are likely to result in data being cached in the Exadata Smart Flash Cache?

Answer: ABD

Section: (none)

Explanation/Reference:

Exadata Smart Flash Cache provides a caching mechanism for frequently accessed data on each Exadata cell. Exadata Smart Flash Cache works in conjunction with Oracle Database to intelligently optimize the efficiency of the cache.

Each database I/O is tagged with the following metadata:

• The CELL_FLASH_CACHE setting for the object associated with the I/O:

- DEFAULT specifies that Exadata Smart Flash Cache is used normally.

- KEEP specifies that Exadata Smart Flash Cache is used more aggressively.

- NONE specifies that Exadata Smart Flash Cache is not used.

When suitable data is inserted into a full cache, a prioritized least recently used (LRU) algorithm determines which data to replace. Objects with a CELL_FLASH_CACHE setting of KEEP are subject to a different cache retention policy than objects with a CELL_FLASH_CACHE setting of

DEFAULT. KEEP objects have priority over DEFAULT objects so that new data from a DEFAULT object will not push out cached data from any KEEP objects. To prevent KEEP objects from monopolizing the cache, they are allowed to occupy no more than 80% of the total cache size.

Also, to prevent unused KEEP objects from indefinitely occupying the cache, they are subject to an additional aging policy, which periodically purges unused KEEP object data.

QUESTION 42

Which assortment of disk on a cell is created by using the CREATE CELL DISK ALL command?