查看RMAN备份进度
查看RMAN备份进度的两条SQL
近期在生产系统重新部署DG时网上收集发现如下两条SQL还是挺好用的,在此作为记录分享一下。
SELECT SID,
SERIAL#,
CONTEXT,
SOFAR,
TOTALWORK,
ROUND(SOFAR / TOTALWORK * 100, 2) “%_COMPLETE”
FROM gV$SESSION_LONGOPS
WHERE OPNAME LIKE ‘RMAN%’ AND OPNAME NOT LIKE ‘%aggregate%’ AND
TOTALWORK[……]