查看oracle的redo日志切换频率，两个sql，原理是一样的，第二个用到了统计函数。
查看oracle的redo日志切换频率
两个sql，原理是一样的，第二个用到了统计函数。
时间单位：分钟
方法一、
select * from v$log a where a.thread# = 1 ;
set line 200
select b.sequence#, b.first_time,a.sequence#,a.first_time,round(((a.first_time-b.first_time)*24)*60,2) from v$log_history a, v$log_history b where a.sequence#=b.sequence#+1 and b.thread#=1 order by a.sequence# desc;
方法二、
set line 200
select sequence#,first_time,nexttime,round(((first_time-nexttime)*24)*60,2) diff from (select sequence#,first_time,lag(first_time) over(order by sequence#) nexttime from v$log_history where thread#=1) order by sequence# desc;
，