数据oracle im,ORACLE IMDDP 并行

本帖最后由 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.dmp  logfile=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

oracle    5414     1  5 17:50 ?        00:03:35 ora_dw00_ora9i1

oracle    8976  6248  0 19:02 pts/2    00: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内部还能并行啊？