1Z0-062 · Question #64
To enable the Database Smart Flash Cache, you configure the following parameters: DB_FLASH_CACHE_FILE = /dev/flash_device_1' , /dev/flash_device_2' DB_FLASH_CACHE_SIZE=64G What is the result when you
The correct answer is A. It results in an error because these parameter settings are invalid.. When configuring Oracle Database Smart Flash Cache with multiple files, each file must have a corresponding size specified in DB_FLASH_CACHE_SIZE. Providing two files but only one size value is an invalid parameter configuration.
Question
To enable the Database Smart Flash Cache, you configure the following parameters:
DB_FLASH_CACHE_FILE = /dev/flash_device_1' , /dev/flash_device_2' DB_FLASH_CACHE_SIZE=64G What is the result when you start up the database instance?
Options
- AIt results in an error because these parameter settings are invalid.
- BOne 64G flash cache file will be used.
- CTwo 64G flash cache files will be used.
- DTwo 32G flash cache files will be used.
How the community answered
(55 responses)- A76% (42)
- B15% (8)
- C5% (3)
- D4% (2)
Why each option
When configuring Oracle Database Smart Flash Cache with multiple files, each file must have a corresponding size specified in DB_FLASH_CACHE_SIZE. Providing two files but only one size value is an invalid parameter configuration.
Oracle requires a one-to-one correspondence between the number of files listed in DB_FLASH_CACHE_FILE and the number of size values in DB_FLASH_CACHE_SIZE. Because two device files are specified but only a single 64G size is provided, Oracle cannot map sizes to each file and raises an error during instance startup. The parameter settings are structurally invalid and the instance will not start successfully.
Oracle does not silently ignore the second file and use only one; the mismatched count between file entries and size entries is treated as an invalid configuration, preventing startup entirely.
Two flash cache files cannot be used because the configuration is invalid - Oracle requires a matching size entry for each file listed in DB_FLASH_CACHE_FILE, which is not satisfied here.
Oracle does not automatically divide a single size value across multiple files; each file requires its own explicit size specification, so no automatic 32G split occurs.
Concept tested: Oracle Database Smart Flash Cache multi-file parameter configuration
Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/admin/managing-the-database-storage-structures.html#GUID-9E33F94A-7A90-4C15-92B2-7EC1FE83B05C
Topics
Community Discussion
No community discussion yet for this question.