Which three 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 parallel Execution performance
• DImproved Serial Execution performance
• EReduced physical I/O
• FReduced CPU utilization

• A
  6% (2)
• B
  87% (27)
• D
  3% (1)
• E
  3% (1)

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.

No community discussion yet for this question.