Objetos por Tablespace - Oracle

select OWNER, SEGMENT_NAME, SEGMENT_TYPE
from dba_segments
where TABLESPACE_NAME='XXX';

Monitorar Processos - RMAN - Oracle

select sid,
serial#,
context,
sofar,
totalwork,
round(sofar/totalwork*100,2) porcentagem
from
v$session_longops
where
opname like 'RMAN%'
and opname not like '%aggregate%'
and totalwork != 0
and sofar <> totalwork

Analise de Backups - RMAN - Oracle

select operation,object_type,status,output_device_type,
to_char(end_time,'DD-MM-RRRR HH24:MI:SS'),
round(MBYTES_PROCESSED/1024,2)
from
v$rman_status
where
operation <> 'CATALOG'
and trunc(end_time)>=trunc(sysdate-1)
order by
end_time;