DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Monday, August 31, 2015

Data Pump Parameter-parallel



Data Pump Parameter-parallel


expdp system/oracle directory=test_dir full=y dumpfile=full2.dmp logfile=full2.log parallel=2




[oracle@oracle11g ~]$ expdp system/oracle directory=test_dir full=y dumpfile=full2.dmp logfile=full2.log parallel=2

Export: Release 11.2.0.3.0 - Production on Mon Aug 31 12:04:17 2015

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting "SYSTEM"."SYS_EXPORT_FULL_01":  system/******** directory=test_dir full=y dumpfile=full2.dmp logfile=full2.log parallel=2
Estimate in progress using BLOCKS method...
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA

Export> status

Job: SYS_EXPORT_FULL_01
  Operation: EXPORT
  Mode: FULL
  State: EXECUTING
  Bytes Processed: 0
  Current Parallelism: 2
  Job Error Count: 0
  Dump File: /u01/dump/full2.dmp
    bytes written: 4,096

Worker 1 Status:
  Process Name: DW00
  State: EXECUTING
  Object Schema: SCOTT
  Object Name: DON
  Object Type: DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
  Completed Objects: 1,398
  Total Objects: 1,398
  Worker Parallelism: 1

Worker 2 Status:
  Process Name: DW01
  State: EXECUTING
  Object Schema: SCOTT
  Object Name: DON
  Object Type: DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
  Completed Objects: 1
  Total Objects: 1,398

  Worker Parallelism: 1

No comments: