数据库版本
SQL*Plus: Release 11.2.0.1.0 Production on Tue Feb 3 02:41:19 2015
Copyright (c) 1982, 2009, Oracle. All rights reserved.
数据库进程
[oracle@seconary ~]$ ps -ef|grep ora_
oracle 3237 1 0 02:41 ? 00:00:00 ora_pmon_guowang
oracle 3239 1 0 02:41 ? 00:00:00 ora_vktm_guowang
oracle 3243 1 0 02:41 ? 00:00:00 ora_gen0_guowang
oracle 3245 1 0 02:41 ? 00:00:00 ora_diag_guowang
oracle 3247 1 0 02:41 ? 00:00:00 ora_dbrm_guowang
oracle 3249 1 0 02:41 ? 00:00:00 ora_psp0_guowang
oracle 3251 1 0 02:41 ? 00:00:00 ora_dia0_guowang
oracle 3253 1 0 02:41 ? 00:00:00 ora_mman_guowang
oracle 3255 1 0 02:41 ? 00:00:00 ora_dbw0_guowang
oracle 3257 1 0 02:41 ? 00:00:00 ora_lgwr_guowang
oracle 3259 1 0 02:41 ? 00:00:00 ora_ckpt_guowang
oracle 3261 1 0 02:41 ? 00:00:00 ora_smon_guowang
oracle 3263 1 0 02:41 ? 00:00:00 ora_reco_guowang
oracle 3265 1 0 02:41 ? 00:00:00 ora_mmon_guowang
oracle 3267 1 0 02:41 ? 00:00:00 ora_mmnl_guowang
oracle 3269 1 0 02:41 ? 00:00:00 ora_d000_guowang
oracle 3271 1 0 02:41 ? 00:00:00 ora_s000_guowang
oracle 3315 1 0 02:41 ? 00:00:00 ora_arc0_guowang
oracle 3317 1 0 02:41 ? 00:00:00 ora_arc1_guowang
oracle 3319 1 0 02:41 ? 00:00:00 ora_arc2_guowang
oracle 3321 1 0 02:41 ? 00:00:00 ora_arc3_guowang
oracle 3352 1 0 02:42 ? 00:00:00 ora_qmnc_guowang
oracle 3391 1 0 02:42 ? 00:00:00 ora_cjq0_guowang
oracle 3403 1 0 02:42 ? 00:00:00 ora_q000_guowang
oracle 3405 1 0 02:42 ? 00:00:00 ora_q001_guowang
oracle 4346 1 0 02:47 ? 00:00:00 ora_smco_guowang
oracle 4357 1 0 02:47 ? 00:00:00 ora_w000_guowang
oracle 6034 3027 0 02:55 pts/0 00:00:00 grep ora_
[oracle@seconary ~]$
1,pnnn用于并行查询,并行DML或并行DDL
SQL> show parameter parallel_max
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
parallel_max_servers integer 20
SQL> show parameter parallel_min_servers
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
parallel_min_servers integer 0
SQL>
SQL> alter system set parallel_min_servers=1;
System altered.
SQL> host ps -ef|grep ora_
oracle 3237 1 0 02:41 ? 00:00:00 ora_pmon_guowang
oracle 3239 1 0 02:41 ? 00:00:00 ora_vktm_guowang
oracle 3243 1 0 02:41 ? 00:00:00 ora_gen0_guowang
oracle 3245 1 0 02:41 ? 00:00:00 ora_diag_guowang
oracle 3247 1 0 02:41 ? 00:00:00 ora_dbrm_guowang
oracle 3249 1 0 02:41 ? 00:00:00 ora_psp0_guowang
oracle 3251 1 0 02:41 ? 00:00:00 ora_dia0_guowang
oracle 3253 1 0 02:41 ? 00:00:00 ora_mman_guowang
oracle 3255 1 0 02:41 ? 00:00:00 ora_dbw0_guowang
oracle 3257 1 0 02:41 ? 00:00:00 ora_lgwr_guowang
oracle 3259 1 0 02:41 ? 00:00:00 ora_ckpt_guowang
oracle 3261 1 0 02:41 ? 00:00:00 ora_smon_guowang
oracle 3263 1 0 02:41 ? 00:00:00 ora_reco_guowang
oracle 3265 1 0 02:41 ? 00:00:00 ora_mmon_guowang
oracle 3267 1 0 02:41 ? 00:00:00 ora_mmnl_guowang
oracle 3269 1 0 02:41 ? 00:00:00 ora_d000_guowang
oracle 3271 1 0 02:41 ? 00:00:00 ora_s000_guowang
oracle 3315 1 0 02:41 ? 00:00:00 ora_arc0_guowang
oracle 3317 1 0 02:41 ? 00:00:00 ora_arc1_guowang
oracle 3319 1 0 02:41 ? 00:00:00 ora_arc2_guowang
oracle 3321 1 0 02:41 ? 00:00:00 ora_arc3_guowang
oracle 3352 1 0 02:42 ? 00:00:00 ora_qmnc_guowang
oracle 3391 1 0 02:42 ? 00:00:00 ora_cjq0_guowang
oracle 3403 1 0 02:42 ? 00:00:00 ora_q000_guowang
oracle 3405 1 0 02:42 ? 00:00:00 ora_q001_guowang
oracle 4346 1 0 02:47 ? 00:00:00 ora_smco_guowang
oracle 8193 1 0 03:07 ? 00:00:00 ora_w000_guowang
oracle 8898 1 0 03:10 ? 00:00:00 ora_p000_guowang
启动一个并行查询会话
SQL> create table t_parallel(a int) parallel 20;
SQL> select /*+ parallel(t,20) */ count(*) from t_parallel;
COUNT(*)
----------
2000000
查询ORACLE后台进程
SQL> host ps -ef|grep ora_
oracle 3237 1 0 02:41 ? 00:00:00 ora_pmon_guowang
oracle 3239 1 0 02:41 ? 00:00:01 ora_vktm_guowang
oracle 3243 1 0 02:41 ? 00:00:00 ora_gen0_guowang
oracle 3245 1 0 02:41 ? 00:00:00 ora_diag_guowang
oracle 3247 1 0 02:41 ? 00:00:00 ora_dbrm_guowang
oracle 3249 1 0 02:41 ? 00:00:00 ora_psp0_guowang
oracle 3251 1 0 02:41 ? 00:00:00 ora_dia0_guowang
oracle 3253 1 0 02:41 ? 00:00:00 ora_mman_guowang
oracle 3255 1 0 02:41 ? 00:00:00 ora_dbw0_guowang
oracle 3257 1 0 02:41 ? 00:00:00 ora_lgwr_guowang
oracle 3259 1 0 02:41 ? 00:00:00 ora_ckpt_guowang
oracle 3261 1 0 02:41 ? 00:00:00 ora_smon_guowang
oracle 3263 1 0 02:41 ? 00:00:00 ora_reco_guowang
oracle 3265 1 0 02:41 ? 00:00:00 ora_mmon_guowang
oracle 3267 1 0 02:41 ? 00:00:00 ora_mmnl_guowang
oracle 3269 1 0 02:41 ? 00:00:00 ora_d000_guowang
oracle 3271 1 0 02:41 ? 00:00:00 ora_s000_guowang
oracle 3315 1 0 02:41 ? 00:00:00 ora_arc0_guowang
oracle 3317 1 0 02:41 ? 00:00:00 ora_arc1_guowang
oracle 3319 1 0 02:41 ? 00:00:00 ora_arc2_guowang
oracle 3321 1 0 02:41 ? 00:00:00 ora_arc3_guowang
oracle 3352 1 0 02:42 ? 00:00:00 ora_qmnc_guowang
oracle 3391 1 0 02:42 ? 00:00:00 ora_cjq0_guowang
oracle 3403 1 0 02:42 ? 00:00:00 ora_q000_guowang
oracle 3405 1 0 02:42 ? 00:00:00 ora_q001_guowang
oracle 4346 1 0 02:47 ? 00:00:00 ora_smco_guowang
oracle 8193 1 0 03:07 ? 00:00:00 ora_w000_guowang
oracle 8898 1 0 03:10 ? 00:00:00 ora_p000_guowang
oracle 9514 1 0 03:13 ? 00:00:00 ora_p001_guowang
oracle 9516 1 0 03:13 ? 00:00:00 ora_p002_guowang
oracle 9518 1 0 03:13 ? 00:00:00 ora_p003_guowang
oracle 9520 1 0 03:13 ? 00:00:00 ora_p004_guowang
oracle 9522 1 0 03:13 ? 00:00:00 ora_p005_guowang
oracle 9524 1 0 03:13 ? 00:00:00 ora_p006_guowang
oracle 9526 1 0 03:13 ? 00:00:00 ora_p007_guowang
oracle 9528 1 0 03:13 ? 00:00:00 ora_p008_guowang
oracle 9530 1 0 03:13 ? 00:00:00 ora_p009_guowang
oracle 9532 1 0 03:13 ? 00:00:00 ora_p010_guowang
oracle 9534 1 0 03:13 ? 00:00:00 ora_p011_guowang
oracle 9536 1 0 03:13 ? 00:00:00 ora_p012_guowang
oracle 9538 1 0 03:13 ? 00:00:00 ora_p013_guowang
oracle 9540 1 0 03:13 ? 00:00:00 ora_p014_guowang
oracle 9544 1 0 03:13 ? 00:00:00 ora_p015_guowang
oracle 9546 1 0 03:13 ? 00:00:00 ora_p016_guowang
oracle 9555 1 0 03:13 ? 00:00:00 ora_p017_guowang
oracle 9557 1 0 03:13 ? 00:00:00 ora_p018_guowang
oracle 9559 1 0 03:13 ? 00:00:00 ora_p019_guowang
oracle 9563 6153 0 03:13 pts/1 00:00:00 /bin/bash -c ps -ef|grep ora_
oracle 9565 9563 0 03:13 pts/1 00:00:00 grep ora_
SQL>
并行查询SQL已经执行完毕,并行服务器进程仍存在
SQL> host ps -ef|grep ora_
oracle 3237 1 0 02:41 ? 00:00:00 ora_pmon_guowang
oracle 3239 1 0 02:41 ? 00:00:01 ora_vktm_guowang
oracle 3243 1 0 02:41 ? 00:00:00 ora_gen0_guowang
oracle 3245 1 0 02:41 ? 00:00:00 ora_diag_guowang
oracle 3247 1 0 02:41 ? 00:00:00 ora_dbrm_guowang
oracle 3249 1 0 02:41 ? 00:00:00 ora_psp0_guowang
oracle 3251 1 0 02:41 ? 00:00:00 ora_dia0_guowang
oracle 3253 1 0 02:41 ? 00:00:00 ora_mman_guowang
oracle 3255 1 0 02:41 ? 00:00:00 ora_dbw0_guowang
oracle 3257 1 0 02:41 ? 00:00:00 ora_lgwr_guowang
oracle 3259 1 0 02:41 ? 00:00:00 ora_ckpt_guowang
oracle 3261 1 0 02:41 ? 00:00:00 ora_smon_guowang
oracle 3263 1 0 02:41 ? 00:00:00 ora_reco_guowang
oracle 3265 1 0 02:41 ? 00:00:00 ora_mmon_guowang
oracle 3267 1 0 02:41 ? 00:00:00 ora_mmnl_guowang
oracle 3269 1 0 02:41 ? 00:00:00 ora_d000_guowang
oracle 3271 1 0 02:41 ? 00:00:00 ora_s000_guowang
oracle 3315 1 0 02:41 ? 00:00:00 ora_arc0_guowang
oracle 3317 1 0 02:41 ? 00:00:00 ora_arc1_guowang
oracle 3319 1 0 02:41 ? 00:00:00 ora_arc2_guowang
oracle 3321 1 0 02:41 ? 00:00:00 ora_arc3_guowang
oracle 3352 1 0 02:42 ? 00:00:00 ora_qmnc_guowang
oracle 3391 1 0 02:42 ? 00:00:00 ora_cjq0_guowang
oracle 3403 1 0 02:42 ? 00:00:00 ora_q000_guowang
oracle 3405 1 0 02:42 ? 00:00:00 ora_q001_guowang
oracle 4346 1 0 02:47 ? 00:00:00 ora_smco_guowang
oracle 8193 1 0 03:07 ? 00:00:00 ora_w000_guowang
oracle 8898 1 0 03:10 ? 00:00:00 ora_p000_guowang
oracle 9514 1 0 03:13 ? 00:00:00 ora_p001_guowang
oracle 9516 1 0 03:13 ? 00:00:00 ora_p002_guowang
oracle 9518 1 0 03:13 ? 00:00:00 ora_p003_guowang
oracle 9520 1 0 03:13 ? 00:00:00 ora_p004_guowang
oracle 9522 1 0 03:13 ? 00:00:00 ora_p005_guowang
oracle 9524 1 0 03:13 ? 00:00:00 ora_p006_guowang
oracle 9526 1 0 03:13 ? 00:00:00 ora_p007_guowang
oracle 9528 1 0 03:13 ? 00:00:00 ora_p008_guowang
oracle 9530 1 0 03:13 ? 00:00:00 ora_p009_guowang
oracle 9532 1 0 03:13 ? 00:00:00 ora_p010_guowang
oracle 9534 1 0 03:13 ? 00:00:00 ora_p011_guowang
oracle 9536 1 0 03:13 ? 00:00:00 ora_p012_guowang
oracle 9538 1 0 03:13 ? 00:00:00 ora_p013_guowang
oracle 9540 1 0 03:13 ? 00:00:00 ora_p014_guowang
oracle 9544 1 0 03:13 ? 00:00:00 ora_p015_guowang
oracle 9546 1 0 03:13 ? 00:00:00 ora_p016_guowang
oracle 9555 1 0 03:13 ? 00:00:00 ora_p017_guowang
oracle 9557 1 0 03:13 ? 00:00:00 ora_p018_guowang
oracle 9559 1 0 03:13 ? 00:00:00 ora_p019_guowang
oracle 9764 6153 0 03:15 pts/1 00:00:00 /bin/bash -c ps -ef|grep ora_
SQL>
调整并行服务器进程,已经存在的并行服务器进程不会减少
SQL> alter system set parallel_max_servers=10;
System altered.
SQL> host ps -ef|grep ora_
oracle 3237 1 0 02:41 ? 00:00:00 ora_pmon_guowang
oracle 3239 1 0 02:41 ? 00:00:01 ora_vktm_guowang
oracle 3243 1 0 02:41 ? 00:00:00 ora_gen0_guowang
oracle 3245 1 0 02:41 ? 00:00:00 ora_diag_guowang
oracle 3247 1 0 02:41 ? 00:00:00 ora_dbrm_guowang
oracle 3249 1 0 02:41 ? 00:00:00 ora_psp0_guowang
oracle 3251 1 0 02:41 ? 00:00:00 ora_dia0_guowang
oracle 3253 1 0 02:41 ? 00:00:00 ora_mman_guowang
oracle 3255 1 0 02:41 ? 00:00:00 ora_dbw0_guowang
oracle 3257 1 0 02:41 ? 00:00:00 ora_lgwr_guowang
oracle 3259 1 0 02:41 ? 00:00:00 ora_ckpt_guowang
oracle 3261 1 0 02:41 ? 00:00:00 ora_smon_guowang
oracle 3263 1 0 02:41 ? 00:00:00 ora_reco_guowang
oracle 3265 1 0 02:41 ? 00:00:00 ora_mmon_guowang
oracle 3267 1 0 02:41 ? 00:00:00 ora_mmnl_guowang
oracle 3269 1 0 02:41 ? 00:00:00 ora_d000_guowang
oracle 3271 1 0 02:41 ? 00:00:00 ora_s000_guowang
oracle 3315 1 0 02:41 ? 00:00:00 ora_arc0_guowang
oracle 3317 1 0 02:41 ? 00:00:00 ora_arc1_guowang
oracle 3319 1 0 02:41 ? 00:00:00 ora_arc2_guowang
oracle 3321 1 0 02:41 ? 00:00:00 ora_arc3_guowang
oracle 3352 1 0 02:42 ? 00:00:00 ora_qmnc_guowang
oracle 3391 1 0 02:42 ? 00:00:00 ora_cjq0_guowang
oracle 3403 1 0 02:42 ? 00:00:00 ora_q000_guowang
oracle 3405 1 0 02:42 ? 00:00:00 ora_q001_guowang
oracle 4346 1 0 02:47 ? 00:00:00 ora_smco_guowang
oracle 8193 1 0 03:07 ? 00:00:00 ora_w000_guowang
oracle 8898 1 0 03:10 ? 00:00:00 ora_p000_guowang
oracle 9514 1 0 03:13 ? 00:00:00 ora_p001_guowang
oracle 9516 1 0 03:13 ? 00:00:00 ora_p002_guowang
oracle 9518 1 0 03:13 ? 00:00:00 ora_p003_guowang
oracle 9520 1 0 03:13 ? 00:00:00 ora_p004_guowang
oracle 9522 1 0 03:13 ? 00:00:00 ora_p005_guowang
oracle 9524 1 0 03:13 ? 00:00:00 ora_p006_guowang
oracle 9526 1 0 03:13 ? 00:00:00 ora_p007_guowang
oracle 9528 1 0 03:13 ? 00:00:00 ora_p008_guowang
oracle 9530 1 0 03:13 ? 00:00:00 ora_p009_guowang
oracle 9532 1 0 03:13 ? 00:00:00 ora_p010_guowang
oracle 9534 1 0 03:13 ? 00:00:00 ora_p011_guowang
oracle 9536 1 0 03:13 ? 00:00:00 ora_p012_guowang
oracle 9538 1 0 03:13 ? 00:00:00 ora_p013_guowang
oracle 9540 1 0 03:13 ? 00:00:00 ora_p014_guowang
oracle 9544 1 0 03:13 ? 00:00:00 ora_p015_guowang
oracle 9546 1 0 03:13 ? 00:00:00 ora_p016_guowang
oracle 9555 1 0 03:13 ? 00:00:00 ora_p017_guowang
oracle 9557 1 0 03:13 ? 00:00:00 ora_p018_guowang
oracle 9559 1 0 03:13 ? 00:00:00 ora_p019_guowang
调整并行服务器最小进程数为0,依旧不会影响已经存在的并行服务器进程
SQL> alter system set parallel_min_servers=0;
System altered.
SQL> host ps -ef|grep ora_
oracle 3237 1 0 02:41 ? 00:00:00 ora_pmon_guowang
oracle 3239 1 0 02:41 ? 00:00:01 ora_vktm_guowang
oracle 3243 1 0 02:41 ? 00:00:00 ora_gen0_guowang
oracle 3245 1 0 02:41 ? 00:00:00 ora_diag_guowang
oracle 3247 1 0 02:41 ? 00:00:00 ora_dbrm_guowang
oracle 3249 1 0 02:41 ? 00:00:00 ora_psp0_guowang
oracle 3251 1 0 02:41 ? 00:00:00 ora_dia0_guowang
oracle 3253 1 0 02:41 ? 00:00:00 ora_mman_guowang
oracle 3255 1 0 02:41 ? 00:00:00 ora_dbw0_guowang
oracle 3257 1 0 02:41 ? 00:00:00 ora_lgwr_guowang
oracle 3259 1 0 02:41 ? 00:00:00 ora_ckpt_guowang
oracle 3261 1 0 02:41 ? 00:00:00 ora_smon_guowang
oracle 3263 1 0 02:41 ? 00:00:00 ora_reco_guowang
oracle 3265 1 0 02:41 ? 00:00:00 ora_mmon_guowang
oracle 3267 1 0 02:41 ? 00:00:00 ora_mmnl_guowang
oracle 3269 1 0 02:41 ? 00:00:00 ora_d000_guowang
oracle 3271 1 0 02:41 ? 00:00:00 ora_s000_guowang
oracle 3315 1 0 02:41 ? 00:00:00 ora_arc0_guowang
oracle 3317 1 0 02:41 ? 00:00:00 ora_arc1_guowang
oracle 3319 1 0 02:41 ? 00:00:00 ora_arc2_guowang
oracle 3321 1 0 02:41 ? 00:00:00 ora_arc3_guowang
oracle 3352 1 0 02:42 ? 00:00:00 ora_qmnc_guowang
oracle 3391 1 0 02:42 ? 00:00:00 ora_cjq0_guowang
oracle 3403 1 0 02:42 ? 00:00:00 ora_q000_guowang
oracle 3405 1 0 02:42 ? 00:00:00 ora_q001_guowang
oracle 4346 1 0 02:47 ? 00:00:00 ora_smco_guowang
oracle 8898 1 0 03:10 ? 00:00:00 ora_p000_guowang
oracle 9514 1 0 03:13 ? 00:00:00 ora_p001_guowang
oracle 9516 1 0 03:13 ? 00:00:00 ora_p002_guowang
oracle 9518 1 0 03:13 ? 00:00:00 ora_p003_guowang
oracle 9520 1 0 03:13 ? 00:00:00 ora_p004_guowang
oracle 9522 1 0 03:13 ? 00:00:00 ora_p005_guowang
oracle 9524 1 0 03:13 ? 00:00:00 ora_p006_guowang
oracle 9526 1 0 03:13 ? 00:00:00 ora_p007_guowang
oracle 9528 1 0 03:13 ? 00:00:00 ora_p008_guowang
oracle 9530 1 0 03:13 ? 00:00:00 ora_p009_guowang
oracle 9532 1 0 03:13 ? 00:00:00 ora_p010_guowang
oracle 9534 1 0 03:13 ? 00:00:00 ora_p011_guowang
oracle 9536 1 0 03:13 ? 00:00:00 ora_p012_guowang
oracle 9538 1 0 03:13 ? 00:00:00 ora_p013_guowang
oracle 9540 1 0 03:13 ? 00:00:00 ora_p014_guowang
oracle 9544 1 0 03:13 ? 00:00:00 ora_p015_guowang
oracle 9546 1 0 03:13 ? 00:00:00 ora_p016_guowang
oracle 9555 1 0 03:13 ? 00:00:00 ora_p017_guowang
oracle 9557 1 0 03:13 ? 00:00:00 ora_p018_guowang
oracle 9559 1 0 03:13 ? 00:00:00 ora_p019_guowang
oracle 10196 1 0 03:17 ? 00:00:00 ora_w000_guowang
oracle 10323 6153 0 03:17 pts/1 00:00:00 /bin/bash -c ps -ef|grep ora_
SQL>
调整表的并行级别为1
SQL> alter table t_parallel parallel 1;
Table altered.
即便用HINT开启并行度为20,其实数据库开启的并行度由parallel_max_servers控制
SQL> select /*+ parallel(t,20) */ count(*) from t_parallel;
COUNT(*)
----------
2000000
SQL> host ps -ef|grep ora_
oracle 3237 1 0 02:41 ? 00:00:00 ora_pmon_guowang
oracle 3239 1 0 02:41 ? 00:00:01 ora_vktm_guowang
oracle 3243 1 0 02:41 ? 00:00:00 ora_gen0_guowang
oracle 3245 1 0 02:41 ? 00:00:00 ora_diag_guowang
oracle 3247 1 0 02:41 ? 00:00:00 ora_dbrm_guowang
oracle 3249 1 0 02:41 ? 00:00:00 ora_psp0_guowang
oracle 3251 1 0 02:41 ? 00:00:00 ora_dia0_guowang
oracle 3253 1 0 02:41 ? 00:00:00 ora_mman_guowang
oracle 3255 1 0 02:41 ? 00:00:00 ora_dbw0_guowang
oracle 3257 1 0 02:41 ? 00:00:00 ora_lgwr_guowang
oracle 3259 1 0 02:41 ? 00:00:00 ora_ckpt_guowang
oracle 3261 1 0 02:41 ? 00:00:00 ora_smon_guowang
oracle 3263 1 0 02:41 ? 00:00:00 ora_reco_guowang
oracle 3265 1 0 02:41 ? 00:00:00 ora_mmon_guowang
oracle 3267 1 0 02:41 ? 00:00:00 ora_mmnl_guowang
oracle 3269 1 0 02:41 ? 00:00:00 ora_d000_guowang
oracle 3271 1 0 02:41 ? 00:00:00 ora_s000_guowang
oracle 3315 1 0 02:41 ? 00:00:00 ora_arc0_guowang
oracle 3317 1 0 02:41 ? 00:00:00 ora_arc1_guowang
oracle 3319 1 0 02:41 ? 00:00:00 ora_arc2_guowang
oracle 3321 1 0 02:41 ? 00:00:00 ora_arc3_guowang
oracle 3352 1 0 02:42 ? 00:00:00 ora_qmnc_guowang
oracle 3391 1 0 02:42 ? 00:00:00 ora_cjq0_guowang
oracle 3403 1 0 02:42 ? 00:00:00 ora_q000_guowang
oracle 3405 1 0 02:42 ? 00:00:00 ora_q001_guowang
oracle 4346 1 0 02:47 ? 00:00:00 ora_smco_guowang
oracle 8898 1 0 03:10 ? 00:00:00 ora_p000_guowang
oracle 9514 1 0 03:13 ? 00:00:00 ora_p001_guowang
oracle 9516 1 0 03:13 ? 00:00:00 ora_p002_guowang
oracle 9518 1 0 03:13 ? 00:00:00 ora_p003_guowang
oracle 9520 1 0 03:13 ? 00:00:00 ora_p004_guowang
oracle 9522 1 0 03:13 ? 00:00:00 ora_p005_guowang
oracle 9524 1 0 03:13 ? 00:00:00 ora_p006_guowang
oracle 9526 1 0 03:13 ? 00:00:00 ora_p007_guowang
oracle 9528 1 0 03:13 ? 00:00:00 ora_p008_guowang
oracle 9530 1 0 03:13 ? 00:00:00 ora_p009_guowang
oracle 10196 1 0 03:17 ? 00:00:00 ora_w000_guowang
小结:
1,parallel_max_servers和parallel_min_servers控制并行服务器进程的最大及最小值
2,如果并行服务器进程已经产生,即使并行会话结束,也不会马上中断产生的并行服务器进程
3,并行查询,并行DML,并行DDL会产生并行服务器进程
个人简介
8年oracle从业经验,具备丰富的oracle技能,目前在国内北京某专业oracle服务公司从事高级技术顾问。
服务过的客户:
中国电信
中国移动
中国联通
中国电通
国家电网
四川达州商业银行
湖南老百姓大药房
山西省公安厅
中国邮政
北京302医院
河北廊坊新奥集团公司
项目经验:
中国电信3G项目AAA系统数据库部署及优化
中国联通CRM数据库性能优化
中国移动10086电商平台数据库部署及优化
湖南老百姓大药房ERR数据库sql优化项目
四川达州商业银行TCBS核心业务系统数据库模型设计和RAC部署及优化
四川达州商业银行TCBS核心业务系统后端批处理存储过程功能模块编写及优化
北京高铁信号监控系统RAC数据库部署及优化
河南宇通客车数据库性能优化
中国电信电商平台核心采购模块表模型设计及优化
中国邮政储蓄系统数据库性能优化及sql优化
北京302医院数据库迁移实施
河北廊坊新奥data guard部署及优化
山西公安厅身份证审计数据库系统故障评估
国家电网上海灾备项目4 node rac+adg
联系方式:
手机:18201115468
qq : 305076427
qq微博: wisdomone1
新浪微博:wisdomone9
qq群:275813900
itpub博客名称:wisdomone1 http://blog.itpub.net/9240380/
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/9240380/viewspace-1425238/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/9240380/viewspace-1425238/