oracle实现多线程,Oracle 12c 数据库系统中的多进程和多线程

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.

多进程Oracle数据库(也称为多用户Oracle数据库)  使用多个进程来运行一个Oracle数据库代码中的不同部分以及额外的Oracle进程(这些额外的进程或者是对于每一个已经连接的用户的进程，或者是多个用户共享的一个或者多个进程)

越来越多的数据库运行在多用户模式下的原因是因为现在的数据库都是同时被不同个用户访问

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 releases earlier than Oracle Database 12c, Oracle processes did not run as threads on UNIX and Linux systems. Starting in Oracle Database 12c, the enables Oracle processes to execute as operating system threads in separate address spaces. When Oracle Database 12c is installed, the database runs in process mode. You must set the THREADED_EXECUTION initialization parameter to TRUE to run the database in threaded mode. In threaded mode, some background processes on UNIX and Linux run as processes (with each process containing one thread), whereas the remaining Oracle processes run as threads within processes.

在数据库实例中的每一个进程都会执行一个特定的任务.通过将数据库和应用的作业拆分非不同的进程,多用户和应用能够同时连接到一个实例中，前提是当前的数据库性能比较好.

在12c之前的版本中 ,Oracle的进程不能以线程为单位在UNIX和Linux环境下运行. 从12c开始,多线程数据库模式能够让 Oracle的进程像操作系统线程一样在独立的地址空间中运行

当12c安装完成后并且数据库进程运行在进程模式下的时候,你必须设置THEARDED_EXECUTION这个初始化参数为TRUE来让数据库运行在线程模式, 在线程模式下，一些在UNIX和Linux以进程方式运行的进程会以进程中的线程模式来运行

In a database running in threaded mode, PMON and DBW might run as operating system processes, whereas LGWR and CMON might run as threads within a single process. Two foreground processes and a parallel execution (PX) server process might run as threads in a second operating system process. A third operating system process might contain multiple foreground threads. Thus, "Oracle process" does not always mean "operating system process."

在数据库运行在线程模式下的时候，PMON还有DBW会以OS进程的方式来运行，但是LGWR和CMON可以以单一进程的多线程方式来运行，两个前台的进程和一个并行执行的服务器进程可以以另外一个操作系统进程的线程模式来运行.磁带第三个操作系统进程可以包含多个前台的线程，因此，Oracle进程并不总是意味着操作系统进程