How to increase the value if the job is running for long time?

select OWNER_NAME,JOB_NAME,STATE from DBA_DATAPUMP_JOBS;

make a note of the job name, which is in executing state and then run the below command

$expdp system/********** attach=SYS_EXPORT_FULL_01

$impdp system/********** attach=SYS_IMPORT_FULL_01

This will open the interactive session for the datapump utility and you can execute the below commands:

> status
> parallel=4 (whichever value you have determined to provide)

And now run status again and it will show that 4 workers have been assigned to the job.

Hope this helps. Best Wishes!!

Oracle World