How to Monitor DataPump

1) Get DataPump job details from database:

SQL>select JOB_NAME,OPERATION,JOB_MODE,DEGREE,ATTACHED_SESSIONS , STATE from dba_datapump_jobs

JOB_NAME                   OPERATION  JOB_MODE   DEGREE     ATTACHED_SESSIONS STATE
-------------------------- ---------- ---------- ---------- ----------------- ------------------------------
SYS_EXPORT_SCHEMA_01       EXPORT     SCHEMA     4          1                 EXECUTING

2) Also the job name can be found from the DataPump log file:

...
..
.
Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Advanced Analytics and Real Application Testing options
Starting "SYS"."SYS_EXPORT_SCHEMA_01": directory= ..... PARALLEL=4

3) Query V$SESSION_LONGOPS:

SQL> select inst_id, username,target_desc,sofar,totalwork,TIME_REMAINING from gV$SESSION_LONGOPS where TIME_REMAINING>1000;

INST_ID    USERNAME  TARGET_DESC  SOFAR     TOTALWORK        TIME_REMAINING
---------- --------- ------------ --------- --------------- ----------------- 
 4         SYS                    248779    4294967296       28121732
 3         SYS                    467021    4294967296       15108237
 3         SYS             EXPORT   8824         21597           2335
 2         SYS                    313184    4294967296       22351992

4)Attach to the running DataPump job:

$ expdp ATTACH=SYS_EXPORT_SCHEMA_01

Export> help
...
..
.
 ------------------------------------------------------------------------------
HELP
 Summarize interactive commands.

KILL_JOB
 Detach and delete job.

PARALLEL
 Change the number of active workers for current job.

REUSE_DUMPFILES
 Overwrite destination dump file if it exists [NO].

START_JOB
 Start or resume current job.
 Valid keyword values are: SKIP_CURRENT.

STATUS
 Frequency (secs) job status is to be monitored where
 the default [0] will show new status when available.

STOP_JOB
 Orderly shutdown of job execution and exits the client.
 Valid keyword values are: IMMEDIATE.

$status
...
..
.

5) Kill the running DataPump job:

Export> KILL_JOB
Are you sure you wish to stop this job ([yes]/no): yes
$
Advertisements
This entry was posted in DataPump and tagged , , , , , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s