Multiple choice

Which of the following statements about an Oracle instance is true?

  1. The redo log buffer is NOT a part of the shared memory area of an Oracle instance.

  2. Multiple instances can be executed on the same computer, each accessing its own physical database.

  3. An Oracle instance is a combination of memory structures, background processes, and user processes.

  4. In a shared server environment, the memory structure component of an instance consists of a single SGA and a single PGA.
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Multiple Oracle instances can run on the same machine, each accessing separate physical databases - this is how Oracle Real Application Clusters (RAC) and standalone instances coexist. Option A is incorrect because redo log buffer IS part of SGA. Option C is incorrect because instances consist of memory structures and background processes, not user processes. Option D is incorrect because shared server environments have one SGA but multiple PGAs (one per server process).

Keep practicing — related questions