DBA_DATAPUMP_SESSIONS

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	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) `OTHER`