DBA_DATAPUMP_SESSIONS

Oracle 11gR1

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

Oracle data dictionary views