Performance Tuning - Question 031

The default buffer cache can be expanded dynamically if needed, but only in granule-size increments of? (Choose two.)

A . 2Mb if the SGA is less than 128Mb

B. 4Mb if the SGA is less than 128Mb

C . 8Mb if the SGA is larger than 128Mb

D . 8Mb if the SGA is less than 128Mb

E. 16Mb if the SGA is larger than 128Mb

Explanation:

Answer B and E: The granule is defined as a unit of allocation in the dynamic SGA. When an SGA component (DB buffer cache, shared pool) is expanded or shrunk, it must be in granule increments. The minimum number of granules allocated is 1 for each of the SGA structures (buffer cache, shared pool, and fixed SGA). The maximum number of granules is determined by MAX_SGA_SIZE, which is measured in bytes.