nerdexam
Oracle

1Z0-060 · Question #171

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

The correct answer is A. reduced CPU utilization E. reduced virtual memory utilization. Oracle Database 12c's multithreaded architecture consolidates background processes into threads within fewer OS processes, directly reducing CPU and virtual memory overhead at the OS level.

New Features for Database Infrastructure and Architecture

Question

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

Options

  • Areduced CPU utilization
  • Breduced physical I/O
  • Cimproved Serial Execution performance
  • Dreduced logical I/O
  • Ereduced virtual memory utilization

How the community answered

(23 responses)
  • A
    96% (22)
  • C
    4% (1)

Why each option

Oracle Database 12c's multithreaded architecture consolidates background processes into threads within fewer OS processes, directly reducing CPU and virtual memory overhead at the OS level.

Areduced CPU utilizationCorrect

Replacing multiple heavyweight OS processes with lightweight threads reduces context-switching overhead and lowers CPU cycles spent on OS-level process scheduling and management.

Breduced physical I/O

Physical I/O is determined by workload patterns and buffer cache effectiveness, not by whether the database uses a multiprocess or multithreaded OS architecture.

Cimproved Serial Execution performance

The multithreaded architecture improves OS-level resource efficiency but has no effect on serial query execution performance, which depends on execution plan selection and optimizer behavior.

Dreduced logical I/O

Logical I/O is governed by SQL workload characteristics and buffer cache sizing, not by the threading model used for background database processes.

Ereduced virtual memory utilizationCorrect

Threads within a single process share the same virtual address space, eliminating the per-process virtual memory overhead that exists when each background process maintains its own separate address space.

Concept tested: Oracle 12c multithreaded architecture OS resource benefits

Source: https://docs.oracle.com/en/database/oracle/oracle-database/12.2/cncpt/process-architecture.html

Topics

#multithreaded architecture#virtual memory utilization#CPU utilization#Oracle process model

Community Discussion

No community discussion yet for this question.

Full 1Z0-060 Practice