Multiple choice

A latch is defined as ____.

  1. a mechanism used by the Oracle optimizer to run user queries in parallel

  2. a mechanism to prevent data files that make up the database from auto-extending

  3. a mechanism used by the background process PMON for cleaning up the caches and freeing up resources the user processes were using

  4. a low-level serialization mechanism to protect shared data structures in the system global area
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

In Oracle databases, a latch is a low-level, highly efficient serialization mechanism used to protect shared data structures in the System Global Area (SGA) from simultaneous access by multiple processes.

Keep practicing — related questions