查看Oracle数据库每天产生归档日志的数据量：selecttrunc(completion_time) as "Date",count(*) as "Count",(sum(blocks * block_size)) /1024 /1024) as "MB"from v$archived_loggroup by trunc(completion_time);转载于:https://blog.51

============= oracle数据库archivelog暴增分析 ====================前言归档量突然增长到981G/天，导致归档目录使用率告警归档日志量异常暴增会导致磁盘空间爆满，数据库异常1、归档日志量统计SELECT TRUNC(FIRST_TIME) "TIME",SUM(BLOCK_SIZE * BLOCKS) / 1024 / 1024 / 1024 "SI