RMAN monitoring



select sofar, totalwork, time_remaining, elapsed_seconds , timestamp, sql_id
from v$session_longops
where opname='RMAN: aggregate input'
--and sofar < totalwork
/


select
       filename,
       bytes,
       io_count,
       ready,
       short_waits sw,
       short_wait_time_total swtm,
       short_wait_time_max swmx,
       long_waits lw
from v$backup_async_io  where STATUS='IN PROGRESS';


col  f_bytes new_value v_bytes
select
       sum(bytes) - &v_bytes  bytes,
       sum(bytes) f_bytes,
       sum(io_count),
       sum(ready),
       sum(short_waits) sw,
       sum(short_wait_time_total) swtm,
       sum(short_wait_time_max) swmx,
       sum(long_waits) lw
from v$backup_async_io  where STATUS='IN PROGRESS';

select
          bytes,
          io_count ct,
          io_time_total tm,
          io_time_max   tmmx,
          discrete_bytes_per_second bps
from v$backup_sync_io where STATUS='IN PROGRESS';






Comments