set lines 200
select to_char(first_time, 'yyyy-mm-dd hh24') "YYYY-mm-dd hh24",
to_char(first_time, 'Dy') "Day",
count(to_char(first_time, 'yyyy-mm-dd hh24')) redolog_count
from v$log_history where first_time > sysdate - 7
group by to_char(first_time, 'yyyy-mm-dd hh24'), to_char(first_time, 'Dy')
order by to_char(first_time, 'yyyy-mm-dd hh24');
Oracle Redo log切换频率
最新推荐文章于 2023-08-28 10:54:24 发布