你想知道RMAN的恢复速度吗？
select sid, serial#, context,
round(sofar/totalwork*100,2) "% Complete",
substr(to_char(sysdate,'yymmdd hh24:mi:ss'),1,15) "Time Now",
elapsed_seconds
from v$session_longops
where compnam = 'dbms_backup_restore'; --> for 8.0
For Oracle8i and Oracle9i:
SELECT SID, 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
RMAN uses two types of rows in V$SESSION_LONGOPS: detail and aggregate rows.
Detail rows describe the files being processed by one job step, while aggregate rows describe
the files processed by all job steps in an RMAN command. A job step is the creation or restore
of one backup set or datafile copy. Detail rows are updated with every buffer that is read or
written during the backup step, so their granularity of update is small. Aggregate rows are updated
when each job step completes, so their granularity of update is large.
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/3345/viewspace-1031749/ ，如需转载，请注明出处，否则将追究法律责任。
最新文章
- relink database
- DDL引起package失效后所碰到的错误-ora-04068
- 用pl/sql实现批量处理
- RAC 安装后listener/tnsnames的load balance配置(TAF)
- 你想知道用RMAN备份时输出到磁带的写速度吗？
- windows平台下oracle快速诊断的一些方法：
- 不用NID改DB_NAME
- 纪念
- Getting ORA-01476 during execution of DBMS_STATS.GATHER_SCHEMA_STATS
- ORA-20000 While Executing dbms_stats.gather_schema_stats
