Datapump Job Process

Datapump Job Process  

ps -ef | grep expdp

ps -ef | grep ora_dm*  master

ps -ef | grep ora_dw*  worker ( paralle 4 then worker 4 )

desc dba_datapump_jobs

Jetstar_SYS@traxmp > /

OWNER_NAME                     JOB_NAME                       STATE

------------------------------ ------------------------------ ------------------------------

SYSTEM                         SYS_EXPORT_SCHEMA_09           EXECUTING

SYSTEM                         SYS_EXPORT_SCHEMA_10           EXECUTING

SYSTEM                         SYS_EXPORT_SCHEMA_08           NOT RUNNING

SYSTEM                         SYS_EXPORT_SCHEMA_05           NOT RUNNING

SYSTEM                         SYS_EXPORT_SCHEMA_03           NOT RUNNING

SYSTEM                         SYS_EXPORT_SCHEMA_01           NOT RUNNING

SYSTEM                         SYS_EXPORT_SCHEMA_07           NOT RUNNING

SYSTEM                         SYS_EXPORT_SCHEMA_04           NOT RUNNING

SYSTEM                         SYS_EXPORT_SCHEMA_02           NOT RUNNING

SYSTEM                         SYS_EXPORT_SCHEMA_06           NOT RUNNING

10 rows selected.

Jetstar_SYS@prod > !date

Wed Jul  5 01:03:11 GMT 2017

Jetstar_SYS@prod >

[oracle@meldc1trx01 ~]$ ps -ef | grep ora_dw*

oracle   15561     1  0 Jul02 ?        00:00:17 ora_dm00_traxmp

oracle   15573     1  0 Jul02 ?        00:03:23 ora_dw00_traxmp

oracle   15589     1  0 Jul02 ?        00:14:34 ora_dw01_traxmp

oracle   15593     1  0 Jul02 ?        00:12:39 ora_dw02_traxmp

oracle   15598     1  0 Jul02 ?        00:06:08 ora_dw03_traxmp

oracle   18542     1  0 Feb13 ?        01:16:00 ora_diag_traxmp

oracle   18546     1  0 Feb13 ?        00:05:04 ora_dbrm_traxmp

oracle   18550     1  0 Feb13 ?        11:31:01 ora_dia0_traxmp

oracle   18558     1  0 Feb13 ?        11:25:56 ora_dbw0_traxmp

oracle   18586     1  0 Feb13 ?        00:00:04 ora_d000_traxmp

oracle   18823     1  0 Jul04 ?        00:00:07 ora_dm0h_traxmp

oracle   18838     1  0 Jul04 ?        00:03:39 ora_dw06_traxmp

oracle   18851     1  2 Jul04 ?        00:16:06 ora_dw07_traxmp

oracle   18855     1  1 Jul04 ?        00:11:32 ora_dw05_traxmp

oracle   18859     1  1 Jul04 ?        00:08:44 ora_dw04_traxmp

oracle   22358 22253  0 01:02 pts/3    00:00:00 grep ora_dw*

You have new mail in /var/spool/mail/oracle