Dear buddy,
Have you confuse that how activity about my databases, if we conside it by using backup size about archive files(oracle) and transaction log
(mssql). we can use the following way.
以下是以MSSQL数据库为例，我们得到数据之后会得到以下示例图：
Yes, you can see the most big transacrion log backup size DB. That is C4.
Seconday , we can use the follow script to check how much size of archive files generated each day or how much of traction log was backuped.
Oracle:
select SUM(blocks)*512/1024/1024 from v$archived_log where completion_time >= TO_DATE(20180107,'yyyymmdd') and completion_time union all
select SUM(blocks)*512/1024/1024 from v$archived_log where completion_time >= TO_DATE(20180107,'yyyymmdd') and completion_time
MSSQL:
select
SUM(cast(backup_size/1024.0/1024.0 as numeric(11,1))) as backup_size_MB
from msdb.dbo.backupset a with (nolock)
join msdb.dbo.backupmediafamily b with (nolock) on b.media_set_id = a.media_set_id
where type='L' and (backup_finish_date >= '2018-01-10' AND backup_finish_date < '2018-01-11')
--- and database_name in ('')
