Monday, April 29, 2024

How to Change Parallelism for a datapump job which is current running in oracle database

Change Parallelism for a datapump job which is current running in oracle database

SELECT owner_name, job_name, operation, job_mode, state 

FROM dba_datapump_jobs


impdp world_sample/world_sample attach=SYS_IMPORT_FULL_01


Import> status


Job: SYS_IMPORT_FULL_01

  Operation: IMPORT

  Mode: FULL

  State: EXECUTING

  Bytes Processed: 4,136,377,784

  Percent Done: 41

  Current Parallelism: 1

  Job Error Count: 0

  Job heartbeat: 1

  Dump File: /u01/app/oracle/admin/oracleiac1/dpdump/world_sample.dmp


Worker 1 Status:

  Instance ID: 1

  Instance name: oracleiac1

  Host name: oraclesrc-2

  Object start time: Monday, 29 April, 2024 15:06:57

  Object status at: Monday, 29 April, 2024 15:06:57

  Process Name: DW00

  State: EXECUTING

  Object Schema: WORLD_SAMPLE

  Object Name: NTC_MAP_WATER_AREA_SIDX

  Object Type: TABLE_EXPORT/TABLE/INDEX/DOMAIN_INDEX/INDEX

  Completed Objects: 5

  Worker Parallelism: 1


Import>



 Import> parallel=16


No comments:

Post a Comment