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