oracle数据泵PARALLEL,EXPDP dumpfile和parallel的关系

命令：

expdp "'/ as sysdba'" dumpfile=al1.dmp,al2.dmp directory=expdp schemas=USR_WMS_CITY parallel=4 compression=all

attach观察expdp导出情况：

$ expdp "'/ as sysdba'" attach=SYS_EXPORT_SCHEMA_05

Job: SYS_EXPORT_SCHEMA_05

Owner: SYS

Operation: EXPORT

Creator Privs: TRUE

GUID: 44C8EA6252512B44E0530701F00AF814

Start Time: Thursday, 29 December, 2016 16:31:45

Mode: SCHEMA

Instance: test

Max Parallelism: 4

EXPORT Job Parameters:

Parameter Name      Parameter Value:

CLIENT_COMMAND        "/******** AS SYSDBA" dumpfile=al1.dmp,al2.dmp directory=expdp schemas=USR_WMS_CITY parallel=4 compression=all

COMPRESSION           ALL

State: EXECUTING

Bytes Processed: 0

Current Parallelism: 4

Job Error Count: 0

Dump File: /data/auto/al1.dmp

bytes written: 4,096

Dump File: /data/auto/al2.dmp

bytes written: 4,096

Worker 1 Status:

Process Name: DW00

State: EXECUTING

Object Schema: USR_WMS_CITY

Object Name: ITEM

Object Type: SCHEMA_EXPORT/TABLE/TABLE_DATA

Completed Objects: 35

Total Objects: 35

Worker Parallelism: 1

Worker 2 Status:

Process Name: DW01

State: EXECUTING

Object Schema: USR_WMS_CITY

Object Name: CON_CONTENT_MOVEHIS

Object Type: SCHEMA_EXPORT/TABLE/TABLE_DATA

Completed Objects: 1

Total Objects: 35

Completed Rows: 5,408,389

Worker Parallelism: 1

Worker 3 Status:

Process Name: DW02

State: EXECUTING

Object Schema: USR_WMS_CITY

Object Name: CON_CONTENT_HISTORYHIS

Object Type: SCHEMA_EXPORT/TABLE/TABLE_DATA

Completed Objects: 1

Total Objects: 35

Completed Rows: 6,535,089

Worker Parallelism: 1

Worker 4 Status:

Process Name: DW03

State: EXECUTING

Object Schema: USR_WMS_CITY

Object Name: CON_CONTENT_HISTORY

Object Type: SCHEMA_EXPORT/TABLE/TABLE_DATA

Completed Objects: 1

Total Objects: 35

Worker Parallelism: 1

Export>

Export> status

Job: SYS_EXPORT_SCHEMA_05

Operation: EXPORT

Mode: SCHEMA

State: EXECUTING

Bytes Processed: 0

Current Parallelism: 4

Job Error Count: 0

Dump File: /data/auto/al1.dmp

bytes written: 4,096

Dump File: /data/auto/al2.dmp

bytes written: 4,096

Worker 1 Status:

Process Name: DW00

State: EXECUTING

Object Schema: USR_WMS_CITY

Object Name: ITEM

Object Type: SCHEMA_EXPORT/TABLE/TABLE_DATA

Completed Objects: 35

Total Objects: 35

Worker Parallelism: 1

Worker 2 Status:

Process Name: DW01

State: EXECUTING

Object Schema: USR_WMS_CITY

Object Name: CON_CONTENT_MOVEHIS

Object Type: SCHEMA_EXPORT/TABLE/TABLE_DATA

Completed Objects: 1

Total Objects: 35

Completed Rows: 26,723,846

Worker Parallelism: 1

Worker 3 Status:

Process Name: DW02

State: EXECUTING

Object Schema: USR_WMS_CITY

Object Name: CON_CONTENT_HISTORYHIS

Object Type: SCHEMA_EXPORT/TABLE/TABLE_DATA

Completed Objects: 1

Total Objects: 35

Completed Rows: 34,458,978

Worker Parallelism: 1

Worker 4 Status:

Process Name: DW03

State: EXECUTING

Object Schema: USR_WMS_CITY

Object Name: CON_CONTENT_HISTORY

Object Type: SCHEMA_EXPORT/TABLE/TABLE_DATA

Completed Objects: 1

Total Objects: 35

Worker Parallelism: 1

Export>

****** 只有2个进程(2个dumpfile)在工作(有completed rows:XXX)