Monday, October 14, 2013

Oracle Database 12c - Performance Enhancement - Multiprocess Multithreaded Architecture (MPMT)

Oracle 12c Database has Multiprocess and Multithreaded (MPMT) architecture which closely shadows Linux/Unix OS process.  This feature would greatly enhance the performance of existing applications running on Database.

Benefits can be seen at CPU, Memory Usage, System Reliability and Parallel Operations level.


Multiprocess Multithreaded Architecture (MPMT)























How to implement Multiprocess and Multithreaded (MPMT) ? 



















How to monitor Multiprocess and Multithreaded (MPMT) ? 


















This Architecture will be mostly favorable on Linux/Unix based OS. 

Oracle process execution architecture for an Oracle database instance depends on the operating system (OS).  For example, an Oracle background process on Windows is a thread of execution within an OS process. On Linux and UNIX, an Oracle background process runs as an OS process.


Reference / Read More: 



1. Oracle Database Concepts
12c Release 1 (12.1)
E17633-20

http://docs.oracle.com/cd/E16655_01/server.121/e17633/process.htm

Section: Multiprocess and Multithreaded Oracle Database Systems

2. Oracle Database New Features Guide
12c Release 1 (12.1)
E17906-16 

http://docs.oracle.com/cd/E16655_01/server.121/e17906/chapter1.htm

No comments:

Post a Comment