nerdexam
Oracle

1Z0-060 · Question #71

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…

The correct answer is A. It results in an error because these parameter settings are invalid. When multiple files are listed in DB_FLASH_CACHE_FILE, an equal number of size values must be provided in DB_FLASH_CACHE_SIZE. Specifying two device files with only one size value is an invalid configuration that prevents startup.

New Features for Performance

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

(53 responses)
  • A
    75% (40)
  • B
    4% (2)
  • C
    6% (3)
  • D
    15% (8)

Why each option

When multiple files are listed in DB_FLASH_CACHE_FILE, an equal number of size values must be provided in DB_FLASH_CACHE_SIZE. Specifying two device files with only one size value is an invalid configuration that prevents startup.

AIt results in an error because these parameter settings are invalid.Correct

Oracle requires a one-to-one correspondence between the entries in DB_FLASH_CACHE_FILE and DB_FLASH_CACHE_SIZE. Because two device files are listed but only a single 64G size value is provided, the parameter count mismatch is invalid and the instance will fail to start with an error rather than silently using partial configuration.

BOne 64G flash cache file will be used.

Oracle does not default to using only the first listed device file when a count mismatch exists; the invalid configuration causes an error, not a fallback to one file.

CTwo 64G flash cache files will be used.

Two flash cache files cannot be initialized because each file requires its own explicit size entry in DB_FLASH_CACHE_SIZE, and only one size is provided.

DTwo 32G flash cache files will be used.

Oracle does not automatically split or divide the single 64G value across multiple device files; each file must have its own corresponding size entry.

Concept tested: Oracle Database Smart Flash Cache parameter count matching

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/refrn/DB_FLASH_CACHE_SIZE.html

Topics

#Database Smart Flash Cache#DB_FLASH_CACHE_FILE#DB_FLASH_CACHE_SIZE#buffer cache

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 1Z0-060 Practice