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.
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)- A96% (22)
- C4% (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.
Replacing multiple heavyweight OS processes with lightweight threads reduces context-switching overhead and lowers CPU cycles spent on OS-level process scheduling and management.
Physical I/O is determined by workload patterns and buffer cache effectiveness, not by whether the database uses a multiprocess or multithreaded OS architecture.
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.
Logical I/O is governed by SQL workload characteristics and buffer cache sizing, not by the threading model used for background database processes.
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
Community Discussion
No community discussion yet for this question.