Multiple choice

A database is running on a server that has 3 CPUs, and has these settings for initialization parameters: db_cache_size= 4M shared_pool_size= 52428800 db_block_size= 2048 large_pool_size= 614400 java_pool_size = 20971520 db_file_multiblock_read_count= 8 parallel_max_servers= 4 What is a valid statement about the above scenario?

  1. Tune the number of latches by setting it to db_cache_size(50*db_block_size)

  2. Tune the number of latches by setting to large_pool_size/1000

  3. Tune the number of latches by setting it to Number of CPUs *1 *2

  4. Oracle9i would automatically calculate the number of latches required, based on the environment defined by the initialization parameters for the database and the operating system level parameters
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

Oracle9i introduced automatic latch calculation based on initialization parameters and OS configuration. Manual latch tuning formulas are obsolete in Oracle9i. The database now determines optimal latch counts dynamically using db_cache_size, db_block_size, CPU count, and other parameters.

Keep practicing — related questions