SELECT SUM(BLOCKS *BLOCK_SIZE )/1024/1024/8/1024 AS "Size(G)",TRUNC(completion_time) FROM v$archived_log
GROUP BY TRUNC(completion_time) order by 2 desc;
查看每天的归档的总量
最新推荐文章于 2024-04-07 09:56:10 发布
SELECT SUM(BLOCKS *BLOCK_SIZE )/1024/1024/8/1024 AS "Size(G)",TRUNC(completion_time) FROM v$archived_log
GROUP BY TRUNC(completion_time) order by 2 desc;