Which three are direct benefits of the multiprocess, multithreaded architecture of Oracle Database
12c when it is enabled?
A.
Reduced logical I/O
B.
Reduced virtual memory utilization
C.
Improved parallel Execution performance
D.
Improved Serial Execution performance
E.
Reduced physical I/O
F.
Reduced CPU utilization
Explanation:
* Multiprocess and Multithreaded Oracle Database Systems
Multiprocess Oracle Database (also called multiuser Oracle Database) uses several processes to
run different parts of the Oracle Database code and additional Oracle processes for the
users—either one process for each connected user or one or more processes shared by multiple
users. Most databases are multiuser because a primary advantage of a database is managing
data needed by multiple users simultaneously.
Each process in a database instance performs a specific job. By dividing the work of the database
and applications into several processes, multiple users and applications can connect to an
instance simultaneously while the system gives good performance.
* In previous releases, Oracle processes did not run as threads on UNIX and Linux systems.
Starting in Oracle Database 12c, the multithreaded Oracle Database model enables Oracle
processes to execute as operating system threads in separate address spaces.
BCF
BCF
B.
Reduced virtual memory utilization
C.
Improved parallel Execution performance
F.
Reduced CPU utilization
Thumbs UP
BCF
BCF
BCF
BCF
Multi-Process Multi-Threaded Architecture: Benefits and Setup
• CPU and memory usage reduction
• Better system reliability
• Better performance for parallel operations
Oracle Database 12c: New Features for Administrators 20 – 23
http://orabase.org/index.php/exam-prepare/1z0-060-prepare/1z0-060-q9/
According to Oracle Database 12c: New Features for Administrators 20 -24, Student Guide – Volume II
-CPU and Memory usage reduction
-Better System reliability
-Better Performance for parallel operations.
Note :
Setting up an Oracle database instance for using multi-process multi-threaded architecture is done by starting the Oracle database instance with the initialization parameter THREADED_EXECUTION set to TRUE
BCF