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(30)

User that initiated the job

JOB_NAME

VARCHAR2(30)

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