Oracle Database12c新特性:多线程模式- Multi-threaded Model
![]()
在Oracle Database 12c中&＃xff0c;Oracle引入了多线程模式&＃xff0c;允许在Windows平台之外的Unix、Linux系统使用多线程模式&＃xff0c;结合多进程与多线程模式&＃xff0c;Oracle可以改进进程管理与性能。
先来看一下多进程与多线程模式下&＃xff0c;Oracle后台进程的对比。下图是多进程模式&＃xff1a;
![]()
下图是多线程模式下&＃xff0c;Oracle数据库启动的后台进程&＃xff1a;
![]()
Multi-process ,Multi-threaded Model 现在作为两种运行模式被支持。如下在Linux系统&＃xff0c;缺省的数据库会启动一系列的后台进程&＃xff1a;
oracle 1727 1 0 Jul11 ? 00:00:57 ora_pmon_core
oracle 1729 1 0 Jul11 ? 00:01:21 ora_psp0_core
oracle 1731 1 3 Jul11 ? 02:30:26 ora_vktm_core
oracle 1735 1 0 Jul11 ? 00:00:24 ora_gen0_core
oracle 1737 1 0 Jul11 ? 00:00:11 ora_mman_core
oracle 1741 1 0 Jul11 ? 00:00:20 ora_diag_core
oracle 1743 1 0 Jul11 ? 00:00:18 ora_dbrm_core
oracle 1745 1 0 Jul11 ? 00:05:02 ora_dia0_core
oracle 1747 1 0 Jul11 ? 00:00:28 ora_dbw0_core
oracle 1749 1 0 Jul11 ? 00:00:14 ora_lgwr_core
oracle 1751 1 0 Jul11 ? 00:01:54 ora_ckpt_core
oracle 1753 1 0 Jul11 ? 00:00:07 ora_lg00_core
oracle 1755 1 0 Jul11 ? 00:00:04 ora_lg01_core
oracle 1757 1 0 Jul11 ? 00:00:15 ora_smon_core
oracle 1759 1 0 Jul11 ? 00:00:03 ora_reco_core
oracle 1761 1 0 Jul11 ? 00:00:12 ora_lreg_core
oracle 1763 1 0 Jul11 ? 00:04:43 ora_mmon_core
oracle 1765 1 0 Jul11 ? 00:03:31 ora_mmnl_core
oracle 1767 1 0 Jul11 ? 00:00:05 ora_d000_core
oracle 1769 1 0 Jul11 ? 00:00:05 ora_s000_core
oracle 1781 1 0 Jul11 ? 00:00:08 ora_p000_core
oracle 1783 1 0 Jul11 ? 00:00:08 ora_p001_core
oracle 1785 1 0 Jul11 ? 00:00:04 ora_tmon_core
oracle 1787 1 0 Jul11 ? 00:00:15 ora_tt00_core
oracle 1789 1 0 Jul11 ? 00:00:12 ora_smco_core
oracle 1791 1 0 Jul11 ? 00:00:05 ora_fbda_core
oracle 1793 1 0 Jul11 ? 00:00:07 ora_w000_core
oracle 1795 1 0 Jul11 ? 00:00:03 ora_aqpc_core
oracle 1799 1 0 Jul11 ? 00:00:08 ora_p002_core
oracle 1801 1 0 Jul11 ? 00:00:08 ora_p003_core
oracle 1803 1 0 Jul11 ? 00:00:08 ora_p004_core
oracle 1805 1 0 Jul11 ? 00:00:08 ora_p005_core
oracle 1807 1 0 Jul11 ? 00:00:08 ora_p006_core
oracle 1809 1 0 Jul11 ? 00:00:08 ora_p007_core
oracle 1811 1 0 Jul11 ? 00:01:49 ora_cjq0_core
oracle 1813 1 0 Jul11 ? 00:00:04 ora_qm02_core
oracle 1817 1 0 Jul11 ? 00:00:04 ora_q002_core
oracle 1819 1 0 Jul11 ? 00:00:03 ora_q003_core
oracle 1933 1 0 Jul11 ? 00:00:07 ora_w001_core
oracle 1971 1 0 Jul11 ? 00:00:07 ora_w002_core
oracle 3175 1 0 Jul11 ? 00:00:06 ora_w003_core
oracle 4941 1 0 Jul12 ? 00:00:06 ora_w004_core
oracle 9621 1 0 Jul12 ? 00:00:04 ora_w005_core
oracle 23548 1 0 06:00 ? 00:02:17 ora_vkrm_core
从数据库内部也可以看到详细的进程信息&＃xff1a;
SQL> select addr,pname,program from v$process
2 /
ADDR PNAME PROGRAM
---------------- ----- ------------------------------------------------
00000000C2965BE0 PSEUDO
00000000C2966D40 PMON oracle&＃64;enmocoredb (PMON)
00000000C2967EA0 PSP0 oracle&＃64;enmocoredb (PSP0)
00000000C2969000 VKTM oracle&＃64;enmocoredb (VKTM)
00000000C296A160 GEN0 oracle&＃64;enmocoredb (GEN0)
00000000C296B2C0 MMAN oracle&＃64;enmocoredb (MMAN)
00000000C296C420 W001 oracle&＃64;enmocoredb (W001)
00000000C296D580 DIAG oracle&＃64;enmocoredb (DIAG)
00000000C296E6E0 DBRM oracle&＃64;enmocoredb (DBRM)
00000000C296F840 DIA0 oracle&＃64;enmocoredb (DIA0)
00000000C29709A0 DBW0 oracle&＃64;enmocoredb (DBW0)
ADDR PNAME PROGRAM
---------------- ----- ------------------------------------------------
00000000C2971B00 LGWR oracle&＃64;enmocoredb (LGWR)
00000000C2972C60 CKPT oracle&＃64;enmocoredb (CKPT)
00000000C2973DC0 LG00 oracle&＃64;enmocoredb (LG00)
00000000C2974F20 LG01 oracle&＃64;enmocoredb (LG01)
00000000C2976080 SMON oracle&＃64;enmocoredb (SMON)
00000000C29771E0 RECO oracle&＃64;enmocoredb (RECO)
00000000C2978340 LREG oracle&＃64;enmocoredb (LREG)
00000000C29794A0 MMON oracle&＃64;enmocoredb (MMON)
00000000C297A600 MMNL oracle&＃64;enmocoredb (MMNL)
00000000C297B760 D000 oracle&＃64;enmocoredb (D000)
00000000C297C8C0 S000 oracle&＃64;enmocoredb (S000)
ADDR PNAME PROGRAM
---------------- ----- ------------------------------------------------
00000000C297DA20 P000 oracle&＃64;enmocoredb (P000)
00000000C297EB80 P001 oracle&＃64;enmocoredb (P001)
00000000C297FCE0 TMON oracle&＃64;enmocoredb (TMON)
00000000C2980E40 TT00 oracle&＃64;enmocoredb (TT00)
00000000C2981FA0 SMCO oracle&＃64;enmocoredb (SMCO)
00000000C2983100 FBDA oracle&＃64;enmocoredb (FBDA)
00000000C2984260 W000 oracle&＃64;enmocoredb (W000)
00000000C29853C0 AQPC oracle&＃64;enmocoredb (AQPC)
00000000C2986520 CJQ0 oracle&＃64;enmocoredb (CJQ0)
00000000C2987680 P002 oracle&＃64;enmocoredb (P002)
00000000C29887E0 P003 oracle&＃64;enmocoredb (P003)
ADDR PNAME PROGRAM
---------------- ----- ------------------------------------------------
00000000C2989940 P004 oracle&＃64;enmocoredb (P004)
00000000C298AAA0 P005 oracle&＃64;enmocoredb (P005)
00000000C298BC00 P006 oracle&＃64;enmocoredb (P006)
00000000C298CD60 P007 oracle&＃64;enmocoredb (P007)
00000000C298DEC0 QM02 oracle&＃64;enmocoredb (QM02)
00000000C298F020 W002 oracle&＃64;enmocoredb (W002)
00000000C2990180 Q002 oracle&＃64;enmocoredb (Q002)
00000000C29912E0 Q003 oracle&＃64;enmocoredb (Q003)
00000000C2992440 VKRM oracle&＃64;enmocoredb (VKRM)
00000000C29935A0 oracle&＃64;enmocoredb (TNS V1-V3)
00000000C2994700 W003 oracle&＃64;enmocoredb (W003)
00000000C2995860 W004 oracle&＃64;enmocoredb (W004)
00000000C29969C0 W005 oracle&＃64;enmocoredb (W005)
通过设置初始化参数 threaded_execution &＃xff0c;可以启用或关闭多线程模式&＃xff0c;该参数缺省值为False&＃xff0c;设置为TRUE启用12c的这个新特性&＃xff1a;
SQL> show parameter threaded_exec
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
threaded_execution boolean FALSE
SQL> alter system set threaded_execution&＃61;true scope&＃61;spfile;
System altered.
该参数重新启动数据库后生效&＃xff0c;但是注意&＃xff0c;多线程模式&＃xff0c;不支持操作系统认证&＃xff0c;不能直接启动数据库&＃xff0c;需要提供SYS的密码认证后方能启动数据库&＃xff1a;
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORA-01017: invalid username/password; logon denied
以下通过用户名和密码登录数据库&＃xff1a;
[oracle&＃64;enmocoredb dbs]$ sqlplus sys/oracle as sysdba
SQL*Plus: Release 12.1.0.1.0 Production on Sun Jul 14 17:05:54 2013
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> col program for a40
SQL> select addr,pname,program from v$process;
ADDR PNAME PROGRAM
---------------- ---------- ----------------------------------------
00000000C2965BE0 PSEUDO
00000000C2966D40 PMON oracle&＃64;enmocoredb (PMON)
00000000C2967EA0 PSP0 oracle&＃64;enmocoredb (PSP0)
00000000C2969000 VKTM oracle&＃64;enmocoredb (VKTM)
00000000C296A160 GEN0 oracle&＃64;enmocoredb (GEN0)
现在在操作系统上启动的进程只有5个(PMON / PSP0 / VKTM / DBW0 / U004 / U005)&＃xff1a;
[oracle&＃64;enmocoredb dbs]$ ps -ef|grep ora_
oracle 27404 1 0 17:00 ? 00:00:00 ora_pmon_core
oracle 27406 1 0 17:00 ? 00:00:00 ora_psp0_core
oracle 27408 1 3 17:00 ? 00:00:05 ora_vktm_core
oracle 27412 1 0 17:00 ? 00:00:00 ora_u004_core
oracle 27418 1 0 17:00 ? 00:00:00 ora_u005_core
oracle 27424 1 0 17:00 ? 00:00:00 ora_dbw0_core
其中U进程是共享线程的"容器进程"&＃xff0c;每个进程可以容纳100个线程&＃xff1a;
SQL> select spid,count(*) from v$process group by spid;
SPID COUNT(*)
------------------------ ----------
1
28278 1
28284 10
28586 100
28806 58
28290 100
28296 1
28280 1
28276 1
启用该参数之后&＃xff0c;需要设置监听器参数 DEDICATED_THROUGH_BROKER_LISTENER&＃61;ON ,如果不设置该参数&＃xff0c;网络进程仍然会以进程模式连接。
By eygle on 2013-07-15 22:14 |
Comments (0) |
Oracle12c/11g | 3110 |
京公网安备 11010802041100号