Oracle expdp parallel参数的设置值与生成文件个数不对应

最新推荐文章于 2024-07-04 15:40:58 发布

lk_db

最新推荐文章于 2024-07-04 15:40:58 发布

阅读量5k

点赞数

CC 4.0 BY-SA版权

分类专栏： Oracle

本文链接：https://blog.youkuaiyun.com/lk_db/article/details/51655794

Oracle 专栏收录该内容

120 篇文章

订阅专栏

在一次实验中，使用Oracle的expdp工具进行全库导出，指定了4个并行执行，然而实际观察到的导出文件数量只有2个。这表明并行参数设置可能并未按预期工作，需要进一步调查原因。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

如下实验，开启4个并行执行expdp,但导出文件仅有2个。

Job: SYS_EXPORT_FULL_04

Owner: SYS
Operation: EXPORT
Creator Privs: TRUE
GUID: 350D6AA85B202FB4E053991B200AE817
Start Time: Sunday, 12 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=y parallel=4 logfile=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 Jun 12 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]$