| Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-01 |
|
|
View PDF |
| Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-01 |
|
|
View PDF |
DBA_DATAPUMP_JOBS identifies all active Data Pump jobs in the database, regardless of their state, on an instance (or on all instances for Real Application Clusters). It also show all Data Pump master tables not currently associated with an active job.
Related View
USER_DATAPUMP_JOBS displays the Data Pump jobs owned by the current user. This view does not display the OWNER_NAME column.
| 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) | |
OPERATION |
VARCHAR2(30) |
Type of job | |
JOB_MODE |
VARCHAR2(30) |
Mode of job | |
STATE |
VARCHAR2(30) |
Current job state | |
DEGREE |
NUMBER |
Number of worker processes performing the operation | |
ATTACHED_SESSIONS |
NUMBER |
Number of sessions attached to the job | |
DATAPUMP_SESSIONS |
NUMBER |
Number of Data Pump sessions participating in the job |
