1Z0-027 · Question #60
You recently upgraded your Exadata image to the latest release; previously you were using 11.2.0.3. At the same time, you decide to address some performance problems as follows: You noticed…
The correct answer is B. Use ALTER TABLE in the database to set CELL_FLASH_CACHE = KEEP for the tables belonging C. Configure Smart Flash Log on the cells to use some of these of the space on the cell flash devices. B: The following command could be used to pin the table CUSTOMERS in Exadata Smart Flash ALTER TABLE customers STORAGE (CELL_FLASH_CACHE KEEP) C: Creating Flash Disks Out Of The Flash Cache When an Exadata cell is installed, by default, all the flash is assigned to be used as…
Question
You recently upgraded your Exadata image to the latest release; previously you were using 11.2.0.3. At the same time, you decide to address some performance problems as follows:
You noticed increased latency for the database log writer, especially during the quarterly battery learn cycle on the cells. You have complaints of erratic performance from certain write-intensive applications. Which two actions could improve performance in these areas?
Options
- AEnable write-back flashcache by setting lunWriteCacheMode to Write Back Mode.
- BUse ALTER TABLE in the database to set CELL_FLASH_CACHE = KEEP for the tables belonging
- CConfigure Smart Flash Log on the cells to use some of these of the space on the cell flash devices.
- DConfigure the table belonging to the affected application using CELLCLI, to the set CELL_FLASH_CACHE
- EConfigure Smart Flash Log on the database server to use server flash memory.
How the community answered
(22 responses)- A9% (2)
- B82% (18)
- D5% (1)
- E5% (1)
Explanation
B: The following command could be used to pin the table CUSTOMERS in Exadata Smart Flash ALTER TABLE customers STORAGE (CELL_FLASH_CACHE KEEP) C: Creating Flash Disks Out Of The Flash Cache When an Exadata cell is installed, by default, all the flash is assigned to be used as flash cache user data is automatically cached using the default caching behavior. Optionally, a portion of the cache can be reserved and used as logical flash disks. These flash disks are treated like any Exadata cell disk in the Exadata cell except they actually reside and are stored as non-volatile disks in the cache. * Pinning Objects In The Flash Cache 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 * There are two techniques provided to manually use and manage the cache. The first enables the pinning of objects in the flash cache. The second supports the creation of logical disks out of the flash for the permanent placement of objects on flash disks.
Topics
Community Discussion
No community discussion yet for this question.