DB_FLASH_CACHE_FILE

DB_FLASH_CACHE_FILE specifies file name(s) for the flash memory or disk group representing a collection of flash memory, for use with Database Smart Flash Cache.

Property	Description
Parameter type	String
Syntax	DB_FLASH_CACHE_FILE = { filename [, filename ] ... | disk group }
Default value	There is no default value.
Modifiable	ALTER SYSTEM
Modifiable in a PDB	No
Basic	No

You can specify up to 16 file names for flash memory devices. For example, if there are three flash raw devices:

db_flash_cache_file = /dev/raw/sda, /dev/raw/sdb, /dev/raw/sdc

Specifying this parameter without also specifying the DB_FLASH_CACHE_SIZE initialization parameter is not allowed.

Enabling Database Smart Flash Cache with TDE Encryption

When enabling Database Smart Flash Cache with TDE encryption, you must additionally configure the wallet with the WALLET_ROOT and TDE_CONFIGURATION initialization parameters.

Smart Flash Cache encrypts blocks with the following behavior based on the setting of TABLESPACE_ENCRYPTION:

• When TABLESPACE_ENCRYPTION is set to AUTO_ENABLE, all buffers will be encrypted in flash cache. You are required to set TABLESPACE_ENCRYPTION to AUTO_ENABLE on Oracle Cloud Infrastructure (OCI).

• When TABLESPACE_ENCRYPTION is set to MANUAL_ENABLE, the buffer will get encrypted in flash cache if the block belongs to an encrypted tablespace. MANUAL_ENABLE is the default for on-premises databases.

• When TABLESPACE_ENCRYPTION is set to DECRYPT_ONLY, all buffers will be written unencrypted in flash cache.

See Also:

• “DB_FLASH_CACHE_SIZE”

• “TABLESPACE_ENCRYPTION”