- DBA_DATAPUMP_JOBS - all active Data Pump jobs and the state of each job
- USER_DATAPUMP_JOBS – summary of the user’s active Data Pump jobs
- DBA_DATAPUMP_SESSIONS – all active user sessions that are attached to a Data Pump Job
- V$SESSION_LONGOPS – shows all progress on each active Data Pump job
15.) Can you adjust the level of parallelism dynamically for more or less resource consumption?
Reference : http://www.scribd.com