4.197 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	NULL	Description
OWNER_NAME	VARCHAR2(128)		User that initiated the job
JOB_NAME	VARCHAR2(128)		User-supplied name for the job (or the default name generated by the server)
INSTANCE_ID	NUMBER		Instance ID
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

See Also:

Oracle Database PL/SQL Packages and Types Reference for more information about the DBMS_DATAPUMP package