Multiple choice technology databases

Which component in the SGA has the dictionary cache?

  1. Buffer cache

  2. Library cache

  3. Shared pool

  4. Program Global Area
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

The Shared Pool in the SGA contains the Library Cache, which itself contains the dictionary cache storing data dictionary information. Buffer cache stores database blocks, and PGA is private memory per server process.

Keep practicing — related questions