原文地址: PLSQL_数据泵导入进度查看Impdp/Expdp Status（案例）
摘要
查看 EXPDP/IMPDP 的进度，当你当如导出的时候，如果数据量比较大，中途有些人会着急，不免想看看进度如何。可以通过以下方法查看
两个视图:
- DBA_DATAPUMP_SESSIONS;
- DBA_DATAPUMP_JOBS
Expdp / Impdp 控制台查看进程状态
查看 IMPDP 进度
查看视图 DBA_DATAPUMP_JOBS
1
2
3
4
5SQL> select * from DBA_DATAPUMP_JOBS;
OWNER_NAME JOB_NAME OPERATION JOB_MODE STATE DEGREE ATTACHED_SESSIONS DATAPUMP_SESSIONS
---------- ------------ ------------- -------------- ---------- --------- ------------------ -----------------------
HD40 SYS_IMPORT_FULL_01 IMPORT FULL EXECUTING 8 1 10查看视图 DBA_DATAPUMP_SESSIONS
1
2
3
4
5
6
7
8
9
10
11
12
13
14SQL> select * from DBA_DATAPUMP_SESSIONS;
OWNER_NAME JOB_NAME INST_ID SADDR SESSION_TYPE
------------------------------ ------------------------------ ---------- ---------------- --------------
HD40 SYS_IMPORT_FULL_01 1 0000000F18DD1730 DBMS_DATAPUMP
HD40 SYS_IMPORT_FULL_01 1 0000000EF0E1F520 MASTER
HD40 SYS_IMPORT_FULL_01 1 0000000F58E61B00 WORKER
HD40 SYS_IMPORT_FULL_01 1 0000000EF8E44408 WORKER
HD40 SYS_IMPORT_FULL_01 1 0000000EF0B051A0 WORKER
HD40 SYS_IMPORT_FULL_01 1 0000000F58B47780 WORKER
HD40 SYS_IMPORT_FULL_01 1 0000000F00E5E848 WORKER
HD40 SYS_IMPORT_FULL_01 1 0000000F10EE0210 WORKER
HD40 SYS_IMPORT_FULL_01 1 0000000F00B167A8 WORKER
HD40 SYS_IMPORT_FULL_01 1 0000000F18B28410 WORKER通过 impdp 控制台查看
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128% impdp hd40/hd40@HXBI attach=SYS_IMPORT_FULL_01
Import: Release 11.2.0.4.0 - Production on Sun Sep 26 17:02:58 2021
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining,
Oracle Database Vault and Real Application Testing options
Job: SYS_IMPORT_FULL_01
Owner: HD40
Operation: IMPORT
Creator Privs: TRUE
GUID: CCE295511CA45D90E0530837A8C0653E
Start Time: Sunday, 26 September, 2021 16:15:28
Mode: FULL
Instance: HXBI
Max Parallelism: 8
EXPORT Job Parameters:
Parameter Name Parameter Value:
CLIENT_COMMAND hd40/******** directory=dump_dir dumpfile=schema_hd40.dmp schemas=hd40 logfile=export_hd40.log
IMPORT Job Parameters:
CLIENT_COMMAND hd40/********@HXBI directory=dump_dir dumpfile=SCHEMA_HD40.DMP full=true logfile=impdp_hd40.log parallel=8 cluster=no
State: EXECUTING
Bytes Processed: 0
Current Parallelism: 8
Job Error Count: 0
Dump File: /data/backup/oracle/dump_dir/SCHEMA_HD40.DMP
Worker 1 Status:
Process Name: DW00
State: EXECUTING
Object Schema: HD40
Object Name: TSHIPDTL
Object Type: SCHEMA_EXPORT/TABLE/TABLE_DATA
Completed Objects: 1
Completed Rows: 25,835,575
Completed Bytes: 50,973,619,608
Percent Done: 10
Worker Parallelism: 1
Worker 2 Status:
Process Name: DW01
State: EXECUTING
Object Schema: HD40
Object Name: TPICKUPDTL
Object Type: SCHEMA_EXPORT/TABLE/TABLE_DATA
Completed Objects: 1
Completed Rows: 43,714,875
Completed Bytes: 45,215,394,256
Percent Done: 15
Worker Parallelism: 1
Worker 3 Status:
Process Name: DW02
State: EXECUTING
Object Schema: HD40
Object Name: TBINVDRPTDTL
Object Type: SCHEMA_EXPORT/TABLE/TABLE_DATA
Completed Objects: 1
Completed Rows: 43,900,953
Completed Bytes: 9,987,347,832
Percent Done: 72
Worker Parallelism: 1
Worker 4 Status:
Process Name: DW03
State: EXECUTING
Object Schema: HD40
Object Name: BI_AREATHEME
Object Type: SCHEMA_EXPORT/TABLE/TABLE_DATA
Completed Objects: 1
Completed Rows: 64,976,906
Completed Bytes: 18,569,534,272
Percent Done: 38
Worker Parallelism: 1
Worker 5 Status:
Process Name: DW04
State: EXECUTING
Object Schema: HD40
Object Name: TALCNTCDTL
Object Type: SCHEMA_EXPORT/TABLE/TABLE_DATA
Completed Objects: 1
Completed Rows: 65,982,587
Completed Bytes: 32,653,340,264
Percent Done: 21
Worker Parallelism: 1
Worker 6 Status:
Process Name: DW05
State: EXECUTING
Object Schema: HD40
Object Name: TBINARTICLELOGSUMMARY
Object Type: SCHEMA_EXPORT/TABLE/TABLE_DATA
Completed Objects: 1
Completed Rows: 55,031,880
Completed Bytes: 31,089,078,168
Percent Done: 22
Worker Parallelism: 1
Worker 7 Status:
Process Name: DW06
State: EXECUTING
Object Schema: HD40
Object Name: BI_SHIPMENT_FREQUENCY
Object Type: SCHEMA_EXPORT/TABLE/TABLE_DATA
Completed Objects: 1
Completed Rows: 64,919,450
Completed Bytes: 15,149,819,320
Percent Done: 46
Worker Parallelism: 1
Worker 8 Status:
Process Name: DW07
State: EXECUTING
Object Schema: HD40
Object Name: BI_CATEGORY
Object Type: SCHEMA_EXPORT/TABLE/TABLE_DATA
Completed Objects: 1
Completed Rows: 84,985,635
Completed Bytes: 7,982,058,496
Percent Done: 88
Worker Parallelism: 1
Import>