1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
| SET line 200
col OPNAME FOR a30
col COMPLETE FOR a10
SELECT SID,
CASE
WHEN OPNAME LIKE '%aggregate%' THEN
'total'
ELSE
OPNAME
END OPNAME,
SOFAR,
TOTALWORK,
ROUND(SOFAR / TOTALWORK * 100, 2) || '%' "Complete"
FROM V$SESSION_LONGOPS
WHERE OPNAME LIKE 'RMAN:%'
AND OPNAME NOT LIKE 'RMAN: aggregate%';
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;
SID OPNAME SERIAL# CONTEXT SOFAR TOTALWORK %_complete
---------- ---------------------------------------------------------------- ---------- ---------- ---------- ---------- ----------
201 RMAN: full datafile restore 36562 1 13593188 18566718 73.21
393 RMAN: full datafile restore 22621 1 11283005 18429822 61.22
394 RMAN: full datafile restore 30941 1 8834585 18430464 47.93
580 RMAN: full datafile restore 45785 1 8666282 18426880 47.03
|
