Oracle Data Pump: Monitoring Job Status

Monitor Job Status in Data Pump

The Data Pump Export and Import client utilities can attach to a job in either logging mode or interactive-command mode.
 
In logging mode, real-time detailed status about the job is automatically displayed during job execution.
 
In interactive-command mode, job status can be displayed on request. The information displayed can include the job description and state, a description of the current operation or item being processed, files being written, and a cumulative status.

A log file can also be optionally written during the execution of a job. The log file summarizes the progress of the job, lists any errors that were encountered during execution of the job, and records the completion status of the job.

An alternative way to determine job status or to get other information about Data Pump jobs, would be to query the DBA_DATAPUMP_JOBS, USER_DATAPUMP_JOBS, or DBA_DATAPUMP_SESSIONS views.


Monitor the Progress :

Data Pump operations that transfer table data (export and import) maintain an entry in the V$SESSION_LONGOPS dynamic performance view indicating the job progress (in megabytes of table data transferred).

Use of the COMPRESSION, ENCRYPTION, ENCRYPTION_ALGORITHM, ENCRYPTION_MODE, ENCRYPTION_PASSWORD, QUERY, and REMAP_DATA parameters are not reflected in the determination of estimate values.

The V$SESSION_LONGOPS columns that are relevant to a Data Pump job are as follows:

    USERNAME - job owner

    OPNAME - job name

    TARGET_DESC - job operation

    SOFAR - megabytes transferred thus far during the job

    TOTALWORK - estimated number of megabytes in the job

    UNITS - megabytes (MB)

    MESSAGE - a formatted status message of the form: 'job_name: operation_name : nnn out of mmm MB done'.