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
OR
$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!!
No comments:
Post a Comment
If you have any queries/ any suggestion please do comment and let me know.