Which two are direct benefits of the multiprocess, multithreaded architecture of Oracle Database 12c when it is enabled?

Question

Options

• AReduced logical I/O
• BReduced virtual memory utilization
• CImproved Serial Execution performance
• DReduced physical I/O
• EReduced CPU utilization

• B
  91% (21)
• C
  4% (1)
• D
  4% (1)

Explanation

Oracle's multithreaded architecture (enabled via THREADED_EXECUTION=TRUE) consolidates server processes into shared threads within fewer OS processes. This directly reduces virtual memory utilization (B) because threads share a single process address space instead of each connection spawning its own heavyweight OS process with its own memory allocation. It also reduces CPU utilization (E) by eliminating the overhead of OS-level context switching between separate processes - thread switching is significantly cheaper than process switching.

The distractors are wrong because logical I/O (A) is governed by buffer cache efficiency and SQL execution, not process architecture. Physical I/O (D) is determined by data access patterns and caching, again unrelated to threading. Serial execution performance (C) is not improved - threading benefits concurrency and resource overhead, not the speed of a single sequential operation (and synchronization overhead can marginally slow it).

Memory tip: Think "threads share → less space (virtual memory) and less sweat (CPU work)." The benefits are about resource overhead, not data access - if an answer mentions I/O, it's a distractor.

No community discussion yet for this question.