SQL> select sid, spid, client_info from v$session
2 join v$process
3 on v$session.paddr=v$process.addr
4 where client_info like '%rman%';
39 7769
rman channel=ORA_DISK_1
48 7767
rman channel=ORA_DISK_1
SQL> select opname, context, sofar, totalwork, round(sofar/totalwork*100,2)
2 "%_complete" from v$session_longops
3 where opname like 'RMAN%'
4 and opname not like '%aggregate%';
RMAN: full datafile backup 1
245040 245040 100
RMAN: full datafile backup 2
148331 148331 100
RMAN: full datafile backup 1
245040 245040 100
RMAN: full datafile backup 2
148331 148331 100
RMAN: full datafile backup 1
245040 245040 100
RMAN: full datafile backup 2
148329 148329 100
RMAN: full datafile backup 1
245040 245040 100
RMAN: full datafile backup 2
148334 148334 100
8 rows selected.
No comments:
Post a Comment