STATUS :
- In data pump, STATUS option used to report the status of the export or import activity in the seconds mentioned as the parameter value.
- Job status should be displayed in logging mode.
- Frequency (secs) job status is to be monitored where the default (0) will show new status when available.
[oracle@18c ~]$ expdp system/oracle directory=DATA_PUMP_DIR dumpfile=emp_prod18c.dmp logfile=emp_prod18c.log STATUS=30
Export: Release 18.0.0.0.0 - Production on Mon Aug 20 20:55:49 2018
Version 18.3.0.0.0
Copyright (c) 1982, 2018, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
Job: SYS_EXPORT_SCHEMA_01
Operation: EXPORT
Mode: SCHEMA
State: EXECUTING
Bytes Processed: 0
Current Parallelism: 1
Job Error Count: 0
Job heartbeat: 0
Dump File: /u01/app/oracle/admin/prod18c/dpdump/emp_prod18c.dmp
bytes written: 4,096
Worker 1 Status:
Instance ID: 0
Object start time: Wednesday, 00 Sat, 0000 0:00:00
Object status at: Wednesday, 00 Sat, 0000 0:00:00
State: UNDEFINED
Starting "SYSTEM"."SYS_EXPORT_SCHEMA_01": system/******** directory=DATA_PUMP_DIR dumpfile=emp_prod18c.dmp logfile=emp_prod18c.log STATUS=30
Job: SYS_EXPORT_SCHEMA_01
Operation: EXPORT
Mode: SCHEMA
State: EXECUTING
Bytes Processed: 0
Current Parallelism: 1
Job Error Count: 0
Job heartbeat: 1
Dump File: /u01/app/oracle/admin/prod18c/dpdump/emp_prod18c.dmp
bytes written: 4,096
Worker 1 Status:
Instance ID: 1
Instance name: prod18c
Host name: 18c.localdomain.com
Object start time: Wednesday, 00 Sat, 0000 0:00:00
Object status at: Monday, 20 August, 2018 20:55:0
Process Name: DW00
State: EXECUTING
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Job: SYS_EXPORT_SCHEMA_01
Operation: EXPORT
Mode: SCHEMA
State: EXECUTING
Bytes Processed: 0
Current Parallelism: 1
Job Error Count: 0
Job heartbeat: 1
Dump File: /u01/app/oracle/admin/prod18c/dpdump/emp_prod18c.dmp
bytes written: 4,096
Worker 1 Status:
Instance ID: 1
Instance name: prod18c
Host name: 18c.localdomain.com
Object start time: Wednesday, 00 Sat, 0000 0:00:00
Object status at: Monday, 20 August, 2018 20:55:0
Process Name: DW00
State: EXECUTING
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Job: SYS_EXPORT_SCHEMA_01
Operation: EXPORT
Mode: SCHEMA
State: EXECUTING
Bytes Processed: 0
Current Parallelism: 1
Job Error Count: 0
Job heartbeat: 1
Dump File: /u01/app/oracle/admin/prod18c/dpdump/emp_prod18c.dmp
bytes written: 4,096
Worker 1 Status:
Instance ID: 1
Instance name: prod18c
Host name: 18c.localdomain.com
Object start time: Wednesday, 00 Sat, 0000 0:00:00
Object status at: Monday, 20 August, 2018 20:55:0
Process Name: DW00
State: EXECUTING
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Job: SYS_EXPORT_SCHEMA_01
Operation: EXPORT
Mode: SCHEMA
State: EXECUTING
Bytes Processed: 0
Current Parallelism: 1
Job Error Count: 0
Job heartbeat: 1
Dump File: /u01/app/oracle/admin/prod18c/dpdump/emp_prod18c.dmp
bytes written: 4,096
Worker 1 Status:
Instance ID: 1
Instance name: prod18c
Host name: 18c.localdomain.com
Object start time: Wednesday, 00 Sat, 0000 0:00:00
Object status at: Monday, 20 August, 2018 20:55:0
Process Name: DW00
State: EXECUTING
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Job: SYS_EXPORT_SCHEMA_01
Operation: EXPORT
Mode: SCHEMA
State: EXECUTING
Bytes Processed: 0
Current Parallelism: 1
Job Error Count: 0
Job heartbeat: 1
Dump File: /u01/app/oracle/admin/prod18c/dpdump/emp_prod18c.dmp
bytes written: 8,192
Worker 1 Status:
Instance ID: 1
Instance name: prod18c
Host name: 18c.localdomain.com
Object start time: Monday, 20 August, 2018 20:55:54
Object status at: Monday, 20 August, 2018 20:55:54
Process Name: DW00
State: EXECUTING
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Job: SYS_EXPORT_SCHEMA_01
Operation: EXPORT
Mode: SCHEMA
State: EXECUTING
Bytes Processed: 0
Current Parallelism: 1
Job Error Count: 0
Job heartbeat: 12
Dump File: /u01/app/oracle/admin/prod18c/dpdump/emp_prod18c.dmp
bytes written: 12,288
Worker 1 Status:
Instance ID: 1
Instance name: prod18c
Host name: 18c.localdomain.com
Object start time: Monday, 20 August, 2018 20:55:54
Object status at: Monday, 20 August, 2018 20:55:58
Process Name: DW00
State: EXECUTING
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Job: SYS_EXPORT_SCHEMA_01
Operation: EXPORT
Mode: SCHEMA
State: EXECUTING
Bytes Processed: 0
Current Parallelism: 1
Job Error Count: 0
Job heartbeat: 1
Dump File: /u01/app/oracle/admin/prod18c/dpdump/emp_prod18c.dmp
bytes written: 12,288
Worker 1 Status:
Instance ID: 1
Instance name: prod18c
Host name: 18c.localdomain.com
Object start time: Monday, 20 August, 2018 20:55:54
Object status at: Monday, 20 August, 2018 20:56:11
Process Name: DW00
State: EXECUTING
Processing object type SCHEMA_EXPORT/TABLE/COMMENT
Job: SYS_EXPORT_SCHEMA_01
Operation: EXPORT
Mode: SCHEMA
State: EXECUTING
Bytes Processed: 0
Current Parallelism: 1
Job Error Count: 0
Job heartbeat: 1
Dump File: /u01/app/oracle/admin/prod18c/dpdump/emp_prod18c.dmp
bytes written: 12,288
Worker 1 Status:
Instance ID: 1
Instance name: prod18c
Host name: 18c.localdomain.com
Object start time: Monday, 20 August, 2018 20:55:54
Object status at: Monday, 20 August, 2018 20:56:14
Process Name: DW00
State: EXECUTING
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
Job: SYS_EXPORT_SCHEMA_01
Operation: EXPORT
Mode: SCHEMA
State: EXECUTING
Bytes Processed: 0
Current Parallelism: 1
Job Error Count: 0
Job heartbeat: 1
Dump File: /u01/app/oracle/admin/prod18c/dpdump/emp_prod18c.dmp
bytes written: 12,288
Worker 1 Status:
Instance ID: 1
Instance name: prod18c
Host name: 18c.localdomain.com
Object start time: Monday, 20 August, 2018 20:55:54
Object status at: Monday, 20 August, 2018 20:56:15
Process Name: DW00
State: EXECUTING
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Job: SYS_EXPORT_SCHEMA_01
Operation: EXPORT
Mode: SCHEMA
State: EXECUTING
Bytes Processed: 0
Current Parallelism: 1
Job Error Count: 0
Job heartbeat: 1
Dump File: /u01/app/oracle/admin/prod18c/dpdump/emp_prod18c.dmp
bytes written: 12,288
Worker 1 Status:
Instance ID: 1
Instance name: prod18c
Host name: 18c.localdomain.com
Access method: direct_path
Object start time: Monday, 20 August, 2018 20:56:19
Object status at: Monday, 20 August, 2018 20:56:20
Process Name: DW00
State: EXECUTING
Object Schema: SYSTEM
Completed Objects: 1
Worker Parallelism: 1
Master table "SYSTEM"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded
Job: SYS_EXPORT_SCHEMA_01
Operation: EXPORT
Mode: SCHEMA
State: EXECUTING
Bytes Processed: 1
Current Parallelism: 1
Job Error Count: 0
Job heartbeat: 1
Dump File: /u01/app/oracle/admin/prod18c/dpdump/emp_prod18c.dmp
bytes written: 12,288
Worker 1 Status:
Instance ID: 1
Instance name: prod18c
Host name: 18c.localdomain.com
Access method: direct_path
Object start time: Monday, 20 August, 2018 20:56:19
Object status at: Monday, 20 August, 2018 20:56:20
Process Name: DW00
State: WORK WAITING
******************************************************************************
Job: SYS_EXPORT_SCHEMA_01
Operation: EXPORT
Mode: SCHEMA
State: EXECUTING
Bytes Processed: 1
Current Parallelism: 1
Job Error Count: 0
Job heartbeat: 1
Dump File: /u01/app/oracle/admin/prod18c/dpdump/emp_prod18c.dmp
bytes written: 12,288
Worker 1 Status:
Instance ID: 1
Instance name: prod18c
Host name: 18c.localdomain.com
Access method: direct_path
Object start time: Monday, 20 August, 2018 20:56:19
Object status at: Monday, 20 August, 2018 20:56:20
Process Name: DW00
State: WORK WAITING
Dump file set for SYSTEM.SYS_EXPORT_SCHEMA_01 is:
Job: SYS_EXPORT_SCHEMA_01
Operation: EXPORT
Mode: SCHEMA
State: EXECUTING
Bytes Processed: 1
Current Parallelism: 1
Job Error Count: 0
Job heartbeat: 1
Dump File: /u01/app/oracle/admin/prod18c/dpdump/emp_prod18c.dmp
bytes written: 12,288
Worker 1 Status:
Instance ID: 1
Instance name: prod18c
Host name: 18c.localdomain.com
Access method: direct_path
Object start time: Monday, 20 August, 2018 20:56:19
Object status at: Monday, 20 August, 2018 20:56:20
Process Name: DW00
State: WORK WAITING
/u01/app/oracle/admin/prod18c/dpdump/emp_prod18c.dmp
Job: SYS_EXPORT_SCHEMA_01
Operation: EXPORT
Mode: SCHEMA
State: COMPLETED
Bytes Processed: 1
Current Parallelism: 1
Job Error Count: 0
Job heartbeat: 1
Dump File: /u01/app/oracle/admin/prod18c/dpdump/emp_prod18c.dmp
bytes written: 12,288
Worker 1 Status:
Instance ID: 1
Instance name: prod18c
Host name: 18c.localdomain.com
Access method: direct_path
Object start time: Monday, 20 August, 2018 20:56:19
Object status at: Monday, 20 August, 2018 20:56:20
Process Name: DW00
State: WORK WAITING
Job "SYSTEM"."SYS_EXPORT_SCHEMA_01" successfully completed at Mon Aug 20 20:56:20 2018 elapsed 0 00:00:31
Catch Me On:- Hariprasath Rajaram
Telegram:https://t.me/joinchat/I_f4DhGF_Zifr9YZvvMkRg
LinkedIn:https://www.linkedin.com/in/hari-prasath-aa65bb19/
Facebook:https://www.facebook.com/HariPrasathdba
FB Group:https://www.facebook.com/groups/894402327369506/
FB Page: https://www.facebook.com/dbahariprasath/?
Twitter: https://twitter.com/hariprasathdba