To configure and enable Database Smart Flash Cache, you must set the DB_FLASH_CACHE_SIZE

parameter to reflect the combined size of the flash devices you intend to use for the cache. In this

scenario, two flash devices are configured: /dev/sdj with 128G and /dev/sdk with 64G.

Determine the combined size of the flash devices intended for the Database Smart Flash Cache. In

this case, it's 128G + 64G = 192G.

However, Oracle documentation suggests setting DB_FLASH_CACHE_SIZE to the exact sizes of the

individual devices, separated by a comma when multiple devices are used.

Modify the parameter in the database initialization file (init.ora or spfile.ora) or using an ALTER

SYSTEM command. Here's the command for altering the system setting:

ALTER SYSTEM SET DB_FLASH_CACHE_SIZE='128G,64G' SCOPE=SPFILE;

Since this is a static parameter, a database restart is required for the changes to take effect.

Upon database startup, it will allocate the Database Smart Flash Cache using the provided sizes for

the specified devices.

It is important to note that MEMORY_TARGET and MEMORY_MAX_TARGET parameters should be

configured independently of DB_FLASH_CACHE_SIZE. They control the Oracle memory management

for the SGA and PGA, and do not directly correlate with the flash cache configuration.

Reference

Oracle Database 19c Documentation on Database Smart Flash Cache

Oracle Support Articles and Community Discussions on DB_FLASH_CACHE_SIZE Configuration