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/f lash_device_1‘,‘ /dev/f lash_device_2‘
How should the D3_flash_cache_size be configured to use both devices?
A.
Set DB_FLASH_CACHE_SIZE=64G.
B.
Set D3_FLASH_CACHE_SIZE=64G, 64G.
C.
Set D3_FLASK_CACKE_SI2E=i28G.
D.
db_flash_cache_SI2E is automatically configured by the instance at startup.
Explanation:
* 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
B
B
B
B. I followed the link and configured this in production db.
https://oracle-base.com/articles/12c/database-smart-flash-cache-12cr1
B:
https://docs.oracle.com/database/121/REFRN/GUID-9B2E54F0-F2C0-4C3A-88B7-C2F64F32376F.htm#REFRN10316
B