Jak monitorovat expdp/impdp job?

SQL> desc dba_datapump_jobs
 Name Null? Type
 ----------------------------------------- -------- ----------------------------
 OWNER_NAME VARCHAR2(30)
 JOB_NAME VARCHAR2(30)
 OPERATION VARCHAR2(30)
 JOB_MODE VARCHAR2(30)
 STATE VARCHAR2(30)
 DEGREE NUMBER
 ATTACHED_SESSIONS NUMBER
 DATAPUMP_SESSIONS NUMBER

SQL> select * from dba_datapump_jobs;

OWNER_NAME JOB_NAME
------------------------------ ------------------------------
OPERATION JOB_MODE
------------------------------ ------------------------------
STATE DEGREE ATTACHED_SESSIONS DATAPUMP_SESSIONS
------------------------------ ---------- ----------------- -----------------
SYS SYS_EXPORT_SCHEMA_01
EXPORT SCHEMA
EXECUTING 1 1 3

[14:37:49 dbserver:export] $ expdp attach=SYS_EXPORT_SCHEMA_01

Export: Release 11.2.0.3.0 - Production on Tue Dec 2 14:38:42 2014

Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.

Username: / as sysdba

Connected to: Oracle Database 11g Release 11.2.0.3.0 - 64bit Production

Job: SYS_EXPORT_SCHEMA_01
 Owner: SYS
 Operation: EXPORT
 Creator Privs: TRUE
 GUID: 093AD2843BFC1D3DE053850E0A0A07BF
 Start Time: Tuesday, 02 December, 2014 12:13:55
 Mode: SCHEMA
 Instance: PROD
 Max Parallelism: 1
 EXPORT Job Parameters:
 Parameter Name Parameter Value:
 CLIENT_COMMAND "/******** AS SYSDBA" schemas=DBA directory=exp_pom_dir dumpfile=PROD_DBA.dmp logfile=PROD_DBA.log
 State: EXECUTING
 Bytes Processed: 95,948,815,296
 Percent Done: 89
 Current Parallelism: 1
 Job Error Count: 0
 Dump File: /TEMP-HDD/export/PROD_DBA.dmp
 bytes written: 95,984,562,176

Worker 1 Status:
 Process Name: DW00
 State: EXECUTING
 Object Schema: DBA
 Object Name: F03B16
 Object Type: SCHEMA_EXPORT/TABLE/TABLE_DATA
 Completed Objects: 33
 Total Objects: 4,762
 Completed Rows: 1,558,865
 Worker Parallelism: 1

Komentáře