impdp 查询导入进度？

导入命令：

impdp zcgl_moe/oracle DIRECTORY=dmp DUMPFILE=zcgl202xxx.dmp TABLES=GAMS_FILES

Import: Release 11.2.0.4.0 - Production on Wed Dec 28 15:10:36 2022

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, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
Master table "ZCGL_MOE"."SYS_IMPORT_TABLE_01" successfully loaded/unloaded
Starting "ZCGL_MOE"."SYS_IMPORT_TABLE_01":  zcgl_moe/******** DIRECTORY=dmp DUMPFILE=zcgl2021111.dmp TABLES=GAMS_FILES 
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA

查询导入进度：

SYS@zcgl>SELECT * FROM DBA_DATAPUMP_SESSIONS;

OWNER_NAME		       JOB_NAME 			 INST_ID SADDR		  SESSION_TYPE
------------------------------ ------------------------------ ---------- ---------------- --------------
ZCGL_MOE		       SYS_IMPORT_TABLE_01		       1 00000010107C2910 DBMS_DATAPUMP
ZCGL_MOE		       SYS_IMPORT_TABLE_01		       1 000000105873C038 MASTER
ZCGL_MOE		       SYS_IMPORT_TABLE_01		       1 0000001000737918 WORKER
[oracle@rac04 ~]$ impdp zcgl_moe/oracle attach=SYS_IMPORT_TABLE_01

Import: Release 11.2.0.4.0 - Production on Wed Dec 28 15:24:26 2022

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, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options

Job: SYS_IMPORT_TABLE_01
  Owner: ZCGL_MOE                       
  Operation: IMPORT                         
  Creator Privs: TRUE                           
  GUID: F0DF10B2CC4AF1D4E053CA651EAC15E4
  Start Time: Wednesday, 28 December, 2022 15:10:40
  Mode: TABLE                          
  Instance: zcgl
  Max Parallelism: 1
  EXPORT Job Parameters:
  Parameter Name      Parameter Value:
     CLIENT_COMMAND        zcgl_moe/******** schemas=zcgl_moe dumpfile=zcgl2021111.dmp DIRECTORY=zcgldata2021111 logfile=zcgl2021111.log 
  IMPORT Job Parameters:
     CLIENT_COMMAND        zcgl_moe/******** DIRECTORY=dmp DUMPFILE=zcgl2021111.dmp TABLES=GAMS_FILES 
  State: EXECUTING                      
  Bytes Processed: 0
  Current Parallelism: 1
  Job Error Count: 0
  Dump File: /home/oracle/dmp/zcgl2021111.dmp
  
Worker 1 Status:
  Process Name: DW00
  State: EXECUTING                      
  Object Schema: ZCGL_MOE
  Object Name: GAMS_FILES
  Object Type: SCHEMA_EXPORT/TABLE/TABLE_DATA
  Completed Objects: 1
  Completed Rows: 69,973
  Completed Bytes: 104,321,085,064
  Percent Done: 74
  Worker Parallelism: 1

Import> status

Job: SYS_IMPORT_TABLE_01
  Operation: IMPORT                         
  Mode: TABLE                          
  State: EXECUTING                      
  Bytes Processed: 0
  Current Parallelism: 1
  Job Error Count: 0
  Dump File: /home/oracle/dmp/zcgl2021111.dmp
  
Worker 1 Status:
  Process Name: DW00
  State: EXECUTING                      
  Object Schema: ZCGL_MOE
  Object Name: GAMS_FILES
  Object Type: SCHEMA_EXPORT/TABLE/TABLE_DATA
  Completed Objects: 1
  Completed Rows: 70,279
  Completed Bytes: 104,321,085,064
  Percent Done: 74
  Worker Parallelism: 1

Import>