QUESTION 67/DB_FLASH_CACHE_FILE/Set DB_FLASH_CACHE_SIZE

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 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?
A. Set DB_FLASH_CACHE_SIZE = 64G.
B. Set DB_FLASH_CACHE_SIZE = 64G, 64G
C. Set DB_FLASH_CACHE_SIZE = 128G.
D. DB_FLASH_CACHE_SIZE is automatically configured by the instance at startup.
Correct Answer: B

* 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/sdc
DB_FLASH_CACHE_SIZE = 32G, 32G, 64G
So 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 64G
New view V$FLASHFILESTAT – it’s used to determine the cumulative latency and read counts of each file| device and compute the average latency

 

您已经安装了两个64G闪存设备，以支持运行在Oracle Linux上的数据库服务器上的数据库智能闪存缓存特性。

您已经设置了参数:

DB_FLASH_CACHE_FILE = / dev / flash_device_1,“/ dev / flash_device_2”

如何配置DB_FLASH_CACHE_SIZE来使用两个设备?

A.设置DB_FLASH_CACHE_SIZE = 64G。

B.设置DB_FLASH_CACHE_SIZE = 64G

C.设置DB_FLASH_CACHE_SIZE = 128G。

D. DB_FLASH_CACHE_SIZE由实例在启动时自动配置。

正确答案是:B

 

 

智能闪存缓存的概念在Oracle 12C和Oracle 11g中的智能闪存缓存中并不新鲜。在这个版本中，Oracle修改了DB Smart Flash cache使用的两个初始化参数。现在你可以定义很多文件|设备和它的大小为“数据库智能闪存缓存”区域。在以前的版本中，只能定义一个文件|设备。

DB_FLASH_CACHE_FILE = /dev/sda， /dev/sdb， /dev/sdc

DB_FLASH_CACHE_SIZE = 32G, 32G, 64G

所以上面的设置定义了3个设备，它们将被“DB智能闪存缓存”使用。

sda造32 g

/dev/sdb造32 g

/dev/sdc - size 64G

新视图V$FLASHFILESTAT -它用于确定累积延迟和每个文件|设备的读取计数，并计算平均延迟