Skip Headers
Oracle® Database Reference
12c Release 1 (12.1)

E17615-24
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

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