查看数据库的归档量
select trunc(completion_time) as ARC_DATE,
count(*) as COUNT,
round((sum(blocks * block_size) / 1024 / 1024/1024), 2) as ARC_G
from v$archived_log
group by trunc(completion_time)
order by trunc(completion_time);
查看数据库某个实例的日志切换速度(分钟)
SQL>select thread#,to_char(FIRST_TIME,‘yyyy-mm-dd hh24:mi:ss’) f_time,SEQUENCE# from v$log_history order by thread#,sequence#;