本文共 363 字,大约阅读时间需要 1 分钟。
每小时归档日志量
select * from (select to_char(first_time,'yyyy-mm-dd hh24') hour,count(*) from v$log_history group by to_char(first_time,'yyyy-mm-dd hh24') order by hour desc) a where rownum<40;
每天归档日志量:
select * from (select to_char(first_time,'yyyy-mm-dd') day,count(*) from v$log_history group by to_char(first_time,'yyyy-mm-dd') order by day desc) a where rownum<30;
转载地址:http://yssof.baihongyu.com/