DBA_DATAPUMP_SESSIONS identifies the user sessions that are attached to a Data Pump job. The information in this view is useful for determining why a stopped Data Pump operation has not gone away.

Column Datatype NULL Description
OWNER_NAME VARCHAR2(30)   User that initiated the job
JOB_NAME VARCHAR2(30)   User-supplied name for the job (or the default name generated by the server)
SADDR RAW(4 | 8)   Address of the session attached to the job. Can be used with V$SESSION view.
SESSION_TYPE VARCHAR2(14)   Data Pump session type:
  • DBMS_DATAPUMP - Data Pump interface process (one for each active instantiation of DBMS_DATAPUMP.OPEN and DBMS_DATAPUMP.ATTACH per job.)

  • MASTER - master control process (one per job)

  • WORKER - worker process (1 to n per job, depending on degree of parallelism)

  • EXTERNAL TABLE - external table data access process (1 to n, depending on degree of parallelism, for jobs that use external tables as the data access method for some tables)