The set value of the Oracle EXPDP parallel parameter does not correspond to the number of generated files ____oracle

Source: Internet
Author: User

The following experiment opens 4 parallel execution EXPDP, but only 2 export files.

Job:sys_export_full_04 Owner:sys
Operation:export
Creator Privs:true
guid:350d6aa85b202fb4e053991b200ae817
Start Time:sunday, June, 2016 11:32:11
Mode:full
Instance:orcl
Max Parallelism:4
EXPORT Job Parameters:
Parameter Name Parameter Value:
Client_command/******** as SYSDBA dumpfile=full_rw%u.dmp DIRECTORY=EXPDP full=yparallel=4Logfile=expdp20160612.log Cluster=no
State:executing
Bytes processed:4,221,861,952
Percent done:15
Current Parallelism:4
Job Error count:0
Dump File:/expdp/full_rw01.dmp
Bytes written:4,221,874,176
Dump File:/expdp/full_rw%u.dmp

Worker 1 Status:
Process name:dw04
State:executing
Object Schema:sysman
Object Name:mgmt_loader_q_n
Object Type:database_export/schema/post_schema/procobj
Completed Objects:6
Total Objects:6
Worker parallelism:1

Worker 2 Status:
Process Name:dw05
State:executing
Object Schema:test
Object NAME:LOG_FM1
Object Type:database_export/schema/table/table_data
Completed Objects:3
Total objects:61,618
Worker parallelism:1

Worker 3 Status:
Process name:dw06
State:executing
Object Schema:test
Object NAME:LOG_FM1
Object Type:database_export/schema/table/table_data
Completed Objects:2
Total objects:61,618
Worker parallelism:1

Worker 4 Status:
Process name:dw07
State:executing
Object Schema:test
Object NAME:LOG_FM1
Object Type:database_export/schema/table/table_data
Completed Objects:2
Total objects:61,618
Worker parallelism:1


export> status
Job:sys_export_full_04
Operation:export
Mode:full
State:executing
Bytes processed:10,538,498,576
Percent done:41
Current Parallelism:4
Job Error count:0
Dump File:/expdp/full_rw01.dmp
Bytes written:10,631,065,600
Dump File:/expdp/full_rw%u.dmp

Worker 1 Status:
Process name:dw04
State:executing
Object Schema:test2
Object NAME:STD_SZ2
Object Type:database_export/schema/table/table_data
Completed objects:4
Total objects:61,618
Worker parallelism:1

Worker 2 Status:
Process Name:dw05
State:executing
Object Schema:test2
Object NAME:STD_HA3
Object Type:database_export/schema/table/table_data
Completed objects:7
Total objects:61,618
Worker parallelism:1

Worker 3 Status:
Process name:dw06
State:executing
Object Schema:test2
Object NAME:HA_JSM3
Object Type:database_export/schema/table/table_data
Completed Objects:6
Total objects:61,618
Worker parallelism:1

Worker 4 Status:
Process name:dw07
State:executing
Object Schema:test2
Object Name:sz_sjs
Object Type:database_export/schema/table/table_data
Completed Objects:6
Total objects:61,618
Worker parallelism:1

[Oracle@lk expdp]$ Du-sh *
8.0K Expdp20160612.log
18G full_rw01.dmp
4.0K full_rw02.dmp
[Oracle@lk expdp]$ tail-f Expdp20160612.log
. . Exported "SYSTEM". " Repcat$_template_refgroups "0 KB 0 rows
. . Exported "SYSTEM". " Repcat$_template_sites "0 KB 0 rows
. . Exported "SYSTEM". " Repcat$_template_targets "0 KB 0 rows
. . Exported "SYSTEM". " Repcat$_user_authorizations "0 KB 0 rows
. . Exported "SYSTEM". " Repcat$_user_parm_values "0 KB 0 rows
. . Exported "SYSTEM". " Sqlplus_product_profile "0 KB 0 rows
Master table "SYS". " Sys_export_full_04 "Successfully loaded/unloaded
******************************************************************************
Dump file set for SYS. Sys_export_full_04 is:
/expdp/full_rw01.dmp
Job "SYS". Sys_export_full_04 "successfully completed at Sun June 12:02:26 2016 elapsed 0 00:30:15

[Oracle@lk expdp]$ Du-sh *
5.9M Expdp20160612.log
21G Full_rw01.dmp
4.0K full_rw02.dmp

[Oracle@lk expdp]$

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.