You have installed two 64G flash devices to support the Database Smart Flash Cache feature on your database server that is running on Oracle Linux.

You have installed two 64G flash devices to support the Database Smart Flash Cache feature on your database server that is running on Oracle Linux.You have set the DB_SMART_FLASH_FILE parameter_DB_FLASH_CACHE_FILE= ‘/dev/flash_device_1 ‘,’ /dev/flash_device_2′ How should the DB_FLASH_CACHE_SIZE be configured to use both devices?* Smart Flash Cache concept is not new in Oracle 12C – DB Smart Flash Cache in Oracle 11g.In this release Oracle has made changes related to both initialization parameters used by DB Smart Flash cache. Now you can define many files|devices and its sizes for “Database Smart Flash Cache” area. In previous releases only one file|device could be defined.DB_FLASH_CACHE_FILE = /dev/sda, /dev/sdb, /dev/sdcDB_FLASH_CACHE_SIZE = 32G, 32G, 64GSo above settings defines 3 devices which will be in use by “DB Smart Flash Cache”/dev/sda – size 32G/dev/sdb – size 32G/dev/sdc – size 64GNew view V$FLASHFILESTAT – it’s used to determine the cumulative latency and read counts of each file|device and compute the average latency

Question:

You have installed two 64G flash devices to support the Database Smart Flash Cache feature on your database server that is running on Oracle Linux.

Options:

Set DB_FLASH_CACHE_ZISE = 64G.

Set DB_FLASH_CACHE_ZISE = 64G, 64G

Set DB_FLASH_CACHE_ZISE = 128G.

DB_FLASH_CACHE_SIZE is automatically configured by the instance at startup.

Correct Answer

The Correct Answer for this Question is

Set DB_FLASH_CACHE_ZISE = 64G, 64G

You may also like...

Leave a Reply

Your email address will not be published. Required fields are marked *