Oracle统计每小时归档量
select trunc(COMPLETION_TIME,'HH24') TIME, SUM(BLOCKS * BLOCK_SIZE)/1024/1024 SIZE_MB
from V$ARCHIVED_LOG
group by trunc (COMPLETION_TIME,'HH24') order by 1;
Oracle统计每小时归档量
select trunc(COMPLETION_TIME,'HH24') TIME, SUM(BLOCKS * BLOCK_SIZE)/1024/1024 SIZE_MB
from V$ARCHIVED_LOG
group by trunc (COMPLETION_TIME,'HH24') order by 1;