The
DBA_DATAPUMP_JOBS and USER_DATAPUMP_JOBS views identify all active Data Pump jobs, regardless of their state, on an instance (or on all instances for Real Application Clusters). They also show all Data Pump master tables not currently associated with an active job. You can use the job information to attach to an active job. Once you are attached to the job, you can stop it, change its parallelism, or monitor its progress. You can use the master table information to restart a stopped job or to remove any master tables that are no longer needed.| Column | Datatype | Description |
|---|---|---|
OWNER_NAME | VARCHAR2(30) | User who initiated the job (valid only for DBA_DATAPUMP_JOBS) |
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) | State of the job |
DEGREE | NUMBER | Number of worker processes performing the operation |
ATTACHED_SESSIONS | NUMBER | Number of sessions attached to the job |
No comments:
Post a Comment