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.

by

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’Flow should the D3_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_FLASFI_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 * 1 2 3 4 5 6 7

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_SIZE=64G.

Set DB_FLASH_CACHE_SIZE=64G, 64G.

Set DB_FLASK_CACKE_SI2E=i28G.

db_flash_cache_SI2E is automatically configured by the instance at startup.

Correct Answer

The Correct Answer for this Question is

Set DB_FLASH_CACHE_SIZE=64G, 64G.

Leave a Comment