Multiple choice

Which of the following caches in SGA is responsible for storing and reusing frequently used SQL statements, their execution plans and stored procedures?

  1. Data dictionary cache

  2. Library cache

  3. Database buffer cache

  4. None of these
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

This cache in SGA is responsible for storing and reusing frequently used SQL statements, their execution plans and stored procedures.

Keep practicing — related questions