用jobs查看Oracle脚步进度,expdp/impdp/rman会话进度查看

oracle11g使用DBA_DATAPUBMP_JOBS和DBA_DATAPUMP_SESSIONS视图来显示数据泵取作业的信息，

查看expdp进度：select * from DBA_DATAPUBMP_JOBS;

select * from DBA_DATAPUMP_SESSIONS;

select sid,serial# from v$session s,dba_datapump_sessions d where s.saddr=d.saddr;

查看impdp进度：SELECT a.tablespace_name,

ROUND (a.total_size) "total_size(MB)",

ROUND (a.total_size) - ROUND (b.free_size, 3) "used_size(MB)",

ROUND (b.free_size, 3) "free_size(MB)",

ROUND (b.free_size / total_size * 100, 2) || '%' free_rate

FROM ( SELECT tablespace_name, SUM (bytes) / 1024 / 1024 total_size

FROM dba_data_files

GROUP BY tablespace_name) a,

( SELECT tablespace_name, SUM (bytes) / 1024 / 1024 free_size

FROM dba_free_space

GROUP BY tablespace_name) b

WHERE a.tablespace_name = b.tablespace_name(+);

查看RMAN备份进度:SELECT SID,OPNAME, SERIAL#, CONTEXT, SOFAR, TOTALWORK,

ROUND(SOFAR/TOTALWORK*100,2) "%_COMPLETE"

FROM V$SESSION_LONGOPS

WHERE OPNAME LIKE 'RMAN%'

AND OPNAME NOT LIKE '%aggregate%'

AND TOTALWORK != 0

AND SOFAR <> TOTALWORK

order by "%_COMPLETE"

desc

最后更新于 2020-07-11 20:46:12 并被添加「expdp rman 会话 impdp 进度」标签，已有 22 位童鞋阅读过。

本站使用「署名 4.0 国际」创作共享协议，可自由转载、引用，但需署名作者且注明文章出处

相关文章