Multiple choice

Which of the following statements is true with regard to the shared pool?

  1. The shared pool CANNOT be dynamically resized.

  2. The shared pool contains only fixed structures.

  3. The shared pool consists of the library cache and buffer cache.

  4. The shared pool stores the most recently executed SQL statements and the most recently accessed data definitions.
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

The shared pool is a memory structure in the SGA that caches parsed SQL statements, PL/SQL code, and data dictionary definitions. It consists of the library cache and dictionary cache, NOT the buffer cache (which stores actual data blocks). This caching eliminates the need to re-parse frequently executed statements, significantly improving performance.

Keep practicing — related questions