Multiple choice technology databases

Shared Pool comprises of following components.

  1. Library Cache

  2. Data Buffer Cache

  3. Data Dictionary Cache

  4. SQL buffer cache
Reveal answer Fill a bubble to check yourself
A,C Correct answer
Explanation

The Shared Pool in Oracle SGA contains the Library Cache (which stores parsed SQL statements and PL/SQL code) and Data Dictionary Cache (which stores data dictionary rows). Data Buffer Cache is a separate SGA component used for caching data blocks from disk, not part of Shared Pool. SQL buffer cache is not a standard Oracle memory component.

Keep practicing — related questions