Shulou(Shulou.com)06/01 Report--

Check the progress of EXPDP/IMPDP

1 two views

When you export like this, if the amount of data is relatively large, some people will be worried and want to see how it is going, which can be seen by using two views:

SQL > select * from dba_datapump_sessions

OWNER_NAME JOB_NAME INST_ID SADDR SESSION_TYPE

GOLDENGATE SYS_EXPORT_SCHEMA_01 1 00000013815E57C0 DBMS_DATAPUMP

GOLDENGATE SYS_EXPORT_SCHEMA_01 1 00000013B14500C8 MASTER

GOLDENGATE SYS_EXPORT_SCHEMA_01 1 0000001381808460 WORKER

Select 'alter system kill session''| | sid | |','| | serial# | |''immediate;' from v$session sdirection dbathing datapumpacks where s.saddr=d.saddr

SQL > select sid,serial# from v$session where s.saddr=d.saddr dbathing datapumpads

SID SERIAL# 1256 53 270 40375 2511 43

According to the job_name incoming call, you can start and shut down the running expdp:

[oracle@qjdsvr1 dmpfile] $expdp goldengate/goldengate attach=SYS_EXPORT_SCHEMA_01

You can query dba_datapump_jobs to see how the data pump job is running, or you can use ATTACH to reconnect the JOB that is still in progress

Each datapump can specify the job name through the job_name parameter. If it is not specified, the system uses the default job name, such as SYS_EXPORT_FULL_01 in the following view

You can also view the details of a long-running datapump job through v$session_longops

Use dba_datapump_jobs to view the parallelism of inverted exports:

Select * from dba_datapump_jobs

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.