本帖最后由 gaopengtttt 于 2013-1-10 11:37 编辑
我导出的时候就是PARALLEL=6 文件没有问题，够多。
impdp system/*** PARALLEL=6 EXCLUDE=STATISTICS JOB_NAME=full_imp cluster=no full=y dumpfile=test:back_%U.dmplogfile=test:back_imp.log;
Import> status
Job: FULL_IMP
Operation: IMPORT
Mode: FULL
State: EXECUTING
Bytes Processed: 45,180,076,072
Percent Done: 24
Current Parallelism: 6
Job Error Count: 0
Dump File: /expdp/back_%u.dmp
Dump File: /expdp/back_01.dmp
Dump File: /expdp/back_02.dmp
Dump File: /expdp/back_03.dmp
Dump File: /expdp/back_04.dmp
Dump File: /expdp/back_05.dmp
Dump File: /expdp/back_06.dmp
Dump File: /expdp/back_07.dmp
Dump File: /expdp/back_08.dmp
Worker 1 Status:
Process Name: DW00
State: EXECUTING
Object Schema: ACRUN
Object Name: T_TFI_EXCHG_LOG
Object Type: DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
Completed Objects: 1
Completed Rows: 10,685,026
Completed Bytes: 64,298,642,512
Percent Done: 64
Worker Parallelism: 3
Worker 2 Status:
Process Name: DW01
State: EXECUTING
Object Schema: REPRUN
Object Name: RPT_PLYEDR_INSRNC
Object Type: DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
Completed Objects: 2
Completed Rows: 1,827,431
Completed Bytes: 3,942,506,408
Percent Done: 27
Worker Parallelism: 1
Worker 3 Status:
Process Name: DW02
State: EXECUTING
Object Schema: ACRUN
Object Name: T_FIN_DCR
Object Type: DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
Completed Objects: 2
Completed Rows: 648,046
Completed Bytes: 3,547,621,608
Percent Done: 5
Worker Parallelism: 1
Worker 4 Status:
Process Name: DW03
State: WORK WAITING
Worker 5 Status:
Process Name: DW04
State: EXECUTING
Object Schema: ACRUN
Object Name: T_CLM_IO_LOG
Object Type: DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
Completed Objects: 2
Completed Rows: 2,431,941
Completed Bytes: 4,447,569,568
Percent Done: 48
Worker Parallelism: 1
Worker 6 Status:
Process Name: DW05
State: WORK WAITING
WORKER启动了6个 但是第一个WORKER 为什么是（Worker Parallelism: 3）3 而4 6 在等待状态？
但是确实3+1+1+1=6
难道WORKER 内部还能并行？但是我看LINUX 进程是一个啊。
SQL> select PID,SPID,PNAME from gv$process where addr='00000000ABBD30F0';
PID SPID
PNAME
---------- ------------------------ -----
49 5414
DW00
[oracle@rac1 expdp]$ ps -ef|grep dw00
oracle5414 15 17:50 ?00:03:35 ora_dw00_ora9i1
oracle897662480 19:02 pts/200:00:00 grep dw00
过后又好了：
Import> status
Job: FULL_IMP
Operation: IMPORT
Mode: FULL
State: EXECUTING
Bytes Processed: 150,300,713,536
Percent Done: 80
Current Parallelism: 6
Job Error Count: 0
Dump File: /expdp/back_%u.dmp
Dump File: /expdp/back_01.dmp
Dump File: /expdp/back_02.dmp
Dump File: /expdp/back_03.dmp
Dump File: /expdp/back_04.dmp
Dump File: /expdp/back_05.dmp
Dump File: /expdp/back_06.dmp
Dump File: /expdp/back_07.dmp
Dump File: /expdp/back_08.dmp
Worker 1 Status:
Process Name: DW00
State: EXECUTING
Object Schema: ACRUN
Object Name: T_PLY_UNDRMSG
Object Type: DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
Completed Objects: 3
Completed Rows: 3,856,891
Completed Bytes: 1,134,168,200
Percent Done: 83
Worker Parallelism: 1
Worker 2 Status:
Process Name: DW01
State: EXECUTING
Object Schema: ACRUN
Object Name: T_FIN_PAYDUE
Object Type: DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
Completed Objects: 5
Completed Rows: 2,646,941
Completed Bytes: 1,012,233,224
Percent Done: 93
Worker Parallelism: 1
Worker 3 Status:
Process Name: DW02
State: EXECUTING
Object Schema: ACRUN
Object Name: MLOG$_T_FIN_CLMDUE
Object Type: DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
Completed Objects: 6
Completed Bytes: 382,792,584
Worker Parallelism: 1
Worker 4 Status:
Process Name: DW03
State: EXECUTING
Object Schema: ACRUN
Object Name: T_PAY_CONFIRM_INFO
Object Type: DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
Completed Objects: 5
Completed Rows: 2,443,790
Completed Bytes: 943,310,104
Percent Done: 83
Worker Parallelism: 1
Worker 5 Status:
Process Name: DW04
State: EXECUTING
Object Schema: ACRUN
Object Name: T_PLY_TGT
Object Type: DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
Completed Objects: 6
Completed Rows: 2,285,353
Completed Bytes: 822,501,496
Percent Done: 64
Worker Parallelism: 1
Worker 6 Status:
Process Name: DW05
State: EXECUTING
Object Schema: ACRUN
Object Name: T_FIN_PREINDRCT_CLMFEE
Object Type: DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
Completed Objects: 5
Completed Rows: 6,042,384
Completed Bytes: 989,435,088
Percent Done: 79
Worker Parallelism: 1
看来WORK内部还能并行啊？ |
