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

About the Author : Anurag Pandey | Database cloud Architect | Oracle | SQL Server | PostgreSQL | AI and Data Platform Enthusiast

Anurag Pandey is a Database Architect with expertise in Oracle, PostgreSQL, SQL Server, Linux, and enterprise database platforms and specializes in database architecture, performance tuning, high availability, disaster recovery, cloud modernization, and operational excellence. With extensive experience in enterprise-scale environments, Anurag is passionate about leveraging AI, automation, and modern data platforms to improve reliability, scalability, and business outcomes. He actively contributes to technical communities through knowledge sharing, architecture guidance, and thought leadership in database and data engineering domains.

Follow more articles at

Visit Blog

Oracle Database Deep Health Check Checklist

Oracle Database Deep Health Check Checklist Recommended assessment levels Level Purpose Typical scope L1 Operational health Availability, sp...