baolei

36 积分	0 好友	14 主题

发消息

[物理/逻辑坏块] expdp 如何使用到parallel ？

1^#

发表于 2013-4-27 22:03:54 | 查看: 4336| 回复: 5

ML 您好：

我在工作中expdp导数据时候通过参数parallel=8 dumpfile=a_%U.dmp 仍然无法开启多进程worker 是怎么回事？
查看了官方文档：

For export and import operations, the parallelism setting (specified with the PARALLEL parameter) should be less than or equal to the number of dump files in the dump file set. If there are not enough dump files, the performance will not be optimal because multiple threads of execution will be trying to access the same dump file.

请问如何实现？？谢谢！

分享0

收藏0 回复只看该作者道具举报

Maclean Liu(刘相兵

2^#

发表于 2013-4-27 22:05:18

1. 你如何观察到没有多个worker的
2、你的具体语句是什么

回复只看该作者道具举报

baolei

3^#

发表于 2013-4-27 22:11:55

nohup expdp system/  directory=exp_dir  full=y  content=metadata_only  dumpfile=aaaa_%U.dmp  parallel=8  logfile=aaa.log &
[1]    14177
oracle@basdw1:/archlog1$ Sending output to nohup.out

oracle@basdw1:/archlog1$ cd exportdir
oracle@basdw1:/archlog1/exportdir$ ls -ltr
total 2371208
drwxr-xr-x 2 oracle    oinstall       96 Apr 27 14:42 aaa
-rw------- 1 oracle    oinstall    5460 Apr 27 18:00 expdp1.log
-rw------- 1 oracle    oinstall 1214033920 Apr 27 18:00 basdw1_01.dmp
-rw------- 1 oracle    oinstall    5453 Apr 27 18:00 nohup.out
-rw------- 1 oracle    oinstall       0 Apr 27 22:08 aaa.log
-rw------- 1 oracle    oinstall    4096 Apr 27 22:08 aaaa_01.dmp
oracle@basdw1:/archlog1/exportdir$
oracle@basdw1:/archlog1/exportdir$
oracle@basdw1:/archlog1/exportdir$ ^C
oracle@basdw1:/archlog1/exportdir$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.5.0 - Production on D??úáù 4?? 27 22:08:20 2013

Copyright (c) 1982, 2010, Oracle.  All Rights Reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select * from dba_datapump_jobs;

OWNER_NAME                   JOB_NAME
------------------------------ ------------------------------
OPERATION
------------------------------------------------------------
JOB_MODE
------------------------------------------------------------
STATE                            DEGREE ATTACHED_SESSIONS DATAPUMP_SESSIONS
------------------------------ ---------- ----------------- -----------------
SYSTEM                      SYS_EXPORT_FULL_01
EXPORT
FULL
EXECUTING                            8                1                3

OWNER_NAME                   JOB_NAME
------------------------------ ------------------------------
OPERATION
------------------------------------------------------------
JOB_MODE
------------------------------------------------------------
STATE                            DEGREE ATTACHED_SESSIONS DATAPUMP_SESSIONS
------------------------------ ---------- ----------------- -----------------
ZWBAK                         SYS_EXPORT_TABLE_01
EXPORT
TABLE
NOT RUNNING                            0                0                0

SQL> quit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

oracle@basdw1:/archlog1/exportdir$ expdp system/××× attach=SYS_EXPORT_FULL_01

Export: Release 10.2.0.5.0 - 64bit Production on D??úáù, 27 4??, 2013 22:09:39

Copyright (c) 2003, 2007, Oracle.  All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

Job: SYS_EXPORT_FULL_01
  Owner: SYSTEM
  Operation: EXPORT
  Creator Privs: FALSE
  GUID: DB582E2ABB423762E04400237D3E233E
  Start Time: D??úáù, 27 4??, 2013 22:08:10
  Mode: FULL
  Instance: basdw1
  Max Parallelism: 8
  EXPORT Job Parameters:
  Parameter Name    Parameter Value:
   CLIENT_COMMAND       system/******** directory=exp_dir full=y content=metadata_only dumpfile=aaaa_%U.dmp parallel=8 logfile=aaa.log
   INCLUDE_METADATA    1
  State: EXECUTING
  Bytes Processed: 0
  Current Parallelism: 8
  Job Error Count: 0
  Dump File: /archlog1/exportdir/aaaa_01.dmp
bytes written: 4,096
  Dump File: /archlog1/exportdir/aaaa_%u.dmp

Worker 1 Status:
  State: EXECUTING

Export> exit

oracle@basdw1:/archlog1/exportdir$ ls -ltr
total 2371210
drwxr-xr-x 2 oracle    oinstall       96 Apr 27 14:42 aaa
-rw------- 1 oracle    oinstall    5460 Apr 27 18:00 expdp1.log
-rw------- 1 oracle    oinstall 1214033920 Apr 27 18:00 basdw1_01.dmp
-rw------- 1 oracle    oinstall    5453 Apr 27 18:00 nohup.out
-rw------- 1 oracle    oinstall    4096 Apr 27 22:08 aaaa_01.dmp
-rw------- 1 oracle    oinstall    468 Apr 27 22:08 aaa.log

回复只看该作者道具举报