Daily Archives: August 10, 2017

How to Monitor DataPump

1) Get DataPump job details from database: SQL>select JOB_NAME,OPERATION,JOB_MODE,DEGREE,ATTACHED_SESSIONS , STATE from dba_datapump_jobs JOB_NAME OPERATION JOB_MODE DEGREE ATTACHED_SESSIONS STATE ————————– ———- ———- ———- —————– —————————— SYS_EXPORT_SCHEMA_01 EXPORT SCHEMA 4 1 EXECUTING 2) Also the job name can be found from … Continue reading

Posted in DataPump | Tagged , , , , , , | Leave a comment